Re: [Veritas-bu] MS-Sql server

The MSSQL backup agent is a little peculiar.

You need to sign in to the server and run the agents GUI to set up the credentials, then quite the GU and launch it again, then you can successfully setup the bch script.

The schedule has a frequency/window for the launching of the bch script, but you need to define a application backup window which is typically 24x7 to allow for manual backups.

In my experience, the first time you run an MSSQL backup, it will fail. Then after that it is fine.

To see what was backed up.

From the modules admin guide:

Using bplist to retrieve SQL Server backups

If you plan to manually create a restore script, rather than through the
NetBackup for SQL Server interface, you can use the bplist command to obtain
restore images. See the NetBackup Commands guides for complete information
about bplist.

To extract all of the NetBackup for SQL Server backups from a specific server for
a specific client, execute the following command from the MS-DOS prompt.
install_path\NetBackup\bin\bplist -C <client> -t 15 -S <server> -R \
where <client> is the host machine on which NetBackup for SQL Server
resides and <server> is the host machine of NetBackup server.
The following example shows how to obtain the list of SQL Server backups
backed up from client juneberry to server cole:
C:\Program Files\NetBackup\bin\bplist -C juneberry -t 15 -S cole -R \
juneberry.MSSQL7.JUNEBERRY.db.pubs.~.7.001of003.20060920101716..C:\
juneberry.MSSQL7.JUNEBERRY.db.pubs.~.7.002of003.20060920101716..C:\
juneberry.MSSQL7.JUNEBERRY.db.pubs.~.7.003of003.20060920101716..C:\
juneberry.MSSQL7.JUNEBERRY.fil.pubs.pubsnew.7.001of001.20060919175149..C:\
juneberry.MSSQL7.JUNEBERRY\NEWINSTANCE.trx.abc.~.7.001of001.20060902170920..C:\
juneberry.MSSQL7.JUNEBERRY\NEWINSTANCE.fg.abc.PRIMARY.7.001of001.20060902170824.C:\
juneberry.MSSQL7.JUNEBERRY\NEWINSTANCE.db.Howard's Barbeque.~.7.001of001.20060901085255..C:\
juneberry.MSSQL7.JUNEBERRY\NEWINSTANCE.inc.Howard's Barbeque.~.7.001of001.20060903108552..C:\
juneberry.MSSQL7.COLE.db.pubs.~.7.001of001.20060907100101..C:\
juneberry.MSSQL7.COLE.db.pubs.~.7.001of001.20060908200234..C:\

On 9/23/2010 1:41 PM, Baumann, Kevin wrote:

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
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu