Re: [Veritas-bu] MS-Sql server
What about just opening the .BCH file to see what is in it. If its $ALL, then all DB's are backed up that SQL is aware of. Using the BAR shows, or the logs (if running) that was described by TAL. Keep us posted on your findings... :-) Simon From: Shekel Tal [mailto:tal.she...@uk.fujitsu.com] Sent: Friday, September 24, 2010 11:32 AM To: WEAVER, Simon (external); Baumann, Kevin; VERITAS-BU@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] MS-Sql server 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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: 24 September 2010 07:13 To: Baumann, Kevin; VERITAS-BU@mailman.eng.auburn.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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Baumann, Kevin Sent: Thursday, September 23, 2010 7:41 PM To: VERITAS-BU@mailman.eng.auburn.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 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 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] MS-Sql server
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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: 24 September 2010 07:13 To: Baumann, Kevin; VERITAS-BU@mailman.eng.auburn.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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Baumann, Kevin Sent: Thursday, September 23, 2010 7:41 PM To: VERITAS-BU@mailman.eng.auburn.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 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Baumann, Kevin Sent: Thursday, September 23, 2010 2:41 PM To: VERITAS-BU@mailman.eng.auburn.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@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
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@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