What about just opening the .BCH file to see what is in it. If its $ALL, then all DB's are backed up that SQL is aware of. Using the BAR shows, or the logs (if running) that was described by TAL. Keep us posted on your findings... :-) Simon
________________________________ From: Shekel Tal [mailto:tal.she...@uk.fujitsu.com] Sent: Friday, September 24, 2010 11:32 AM To: WEAVER, Simon (external); Baumann, Kevin; VERITAS-BU@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] MS-Sql server Hi Kevin If you use INSTANCE $ALL and DATABASE $ALL NetBackup will automatically try and backup every DB and Instance on the server. You can either logon to the server as has been described and use the SQL client GUI to check the client progress log. An easier method is to just remotely look at the log file generated which is used to display the job status in the sql gui. You can just connect to the server $ share as opposed to having to log on and then launch the client gui The path would be /install_path\veritas\netbackup\logs\user_ops\mssql\logs There will be a file for each job in that folder with the bottom of the file summarising the failures and successes. BTW - Are your SQL clients on 6.5.6 too? Pre 6.5.6 there was a bug in the sql agent which caused some databases to be skipped from backup and not reported on when using $ALL Regards, Tal ________________________________ From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: 24 September 2010 07:13 To: Baumann, Kevin; VERITAS-BU@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] MS-Sql server Hi Kevin There is normally a "Parent" Job that kicks off. After this, there should be child jobs for each Database. Was the .bch file configured with the ALL$ command? Also, to clarify, goto the Backup, Archive, Restore tool, specify the client machine and the policy type, in your case MS-SQL-Server. You would run this BAR tool on the Master Server (assuming its a client). Hope this helps Simon ________________________________ From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Baumann, Kevin Sent: Thursday, September 23, 2010 7:41 PM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] MS-Sql server All, My Windows team has asked me if I can see what databases have been backed up on a particular Windows server. It is running MS-SQL, and when the master server kicks off the backup it looks at a .bch script on that server. It looks to me like the backups work, but I cannot find a way to say what actual databases were backed up. Is there an easy way to do that? And can I assume that if I get a status 0, that all the databases in the .bch file get backed up? Linux master/media server, 6.5.6. Client is Windows 2003 server (r2) running MS-Sql server. Thanks. -Kevin This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu