How can I get SQL databse name in backup details?
I am taking SQL server database backup using script and intelligent policies. I want to generate a report with the dabase name So that I can identify and be insure that my all databases has been backedup. Is there any possibility to generate the report from OpsCenter analytics, CLI or script? Please suggest.Solved896Views0likes2Comments
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 shownbelow: 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 addingVDITIMEOUTSECONDS 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!638Views0likes1Comment