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-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of WEAVER, Simon
(external)
Sent: 24 September
2010 07:13
To: Baumann, Kevin;
VERITAS-BU AT mailman.eng.auburn DOT 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-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