SQL Database wont backup
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:
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:
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!