Re: [Veritas-bu] MS-Sql server

Launch the MS-SQL Wizard from the server and look for backups in the last 24 hours (or whatever time frame you are interested in.) Each database with images will be listed, as well as whether the backups are full or transaction logs. You can also get this information from the activity monitor. The “file list” in the child jobs looks like /<SERVER>.MSSQL7.<SERVER>.trx.<DATABASE>.~.7.001of001.20100919200348..C. It’s possible this is in the output of BPDBJOBS as well.

-Jonathan

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 2: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

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