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

 

 

 

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-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Baumann, Kevin
Sent: Thursday, September 23, 2010 7:41 PM
To: VERITAS-BU AT mailman.eng.auburn DOT 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