cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Database wont backup

modi1234
Level 3

Hi Community,

I am trying to backup an sql databse on windows 7 client from windows server 2016 master. When I run the job manually I get 2 jobs on activity monitor as shown below:jobs.PNG

On Sql client agent I see following output:

INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\mySQLDB_Backup.bch, Op# = 1
INF - Using backup image client.MSSQL7.client.db.myTestDB.~.7.001of001.20180712102815..C
INF - backup database "myTestDB" to VIRTUAL_DEVICE='VNBU0-4252-5020-1531409296' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <client server>. Connection timeout is <300> seconds.
Backup started Thu Jul 12 10:28:17 2018

This is my script file:

OPERATION BACKUP
DATABASE "myTestDB"
SQLHOST "client server"
NBSERVER "master server"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
VDITIMEOUTSECONDS 900

I have created following log folders:

On client: bpcd and dbclient
On master: bprd (restart NetBackup Request service after creating log folder)
On media server: bpbrm and bptm

and my media server properties looks like this:

media server properties.PNG

 After changing timeouts and adding VDITIMEOUTSECONDS 900 I have also restarted media, master and client services. 

Can anyone please help me figure out what's going on here? Stuck on this since long time. I am able to do backup of files from the same client only sql isn't working.

thanks!

1 REPLY 1

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified