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