The backup of MS-SQL is done by batch jobs initiated from the MS-SQL server itself so it seems any restore would likewise have to be done that way. I verified I get the same results you do when checking one of our MS-SQL backups with bplist on our Linux master.
Checking for this I did find this cached article at Google: http://webcache.googleusercontent.com/search?q=cache:bRMhhXHYkD4J:https://support.symantec.com/en_US/article.TECH23166.html+&cd=1&hl=en&ct=clnk&gl=us That suggests you do in fact need to run bplist on the MS-SQL server itself rather than from your Netbackup master like you’d do for standard backups. I haven’t tried this myself as I’m not the Windows admin here. If I read it right the bplist will create the file you can use to do the restore with. It also notes you’d have to modify the restore file bplist creates if you do not want to overwrite the original database. From: [email protected] [mailto:[email protected]] On Behalf Of Ron Jack Sent: Wednesday, July 15, 2015 4:19 PM To: Patrick Cc: [email protected] Subject: Re: [Veritas-bu] Using BPLIST and BPRESTORE on Windows I've always had to specify a path at the end of a bplist command. But I've never tried it with a DB. On Wed, Jul 15, 2015 at 3:20 PM, Patrick <[email protected]<mailto:[email protected]>> wrote: Have you tried it with less parameters. I find it is usually better to use as few as possible until I get an output, the add them back till I reach the ones I need. bppllist is one of the most difficult commands to get right, but it can be done, you just need perseverance. :) ------ Original Message ------ From: "itsonlyme4" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Sent: 13/07/2015 19:55:09 Subject: [Veritas-bu] Using BPLIST and BPRESTORE on Windows We are running SQL Server 2008 R2 in an Active\Passive Cluster on Windows 2008R2. We now have the need to recover this Server and it's Databases at our Disaster Recovery site. We will NOT be setting up the Cluster at the Disaster Recovery site, only a standalone Server which we will recover the Databases to. We are running Netbackup 7.5 and the 7.5 Client (SQL Server Agent) on our cluster, the SQL Server connection properties page in the Netbackup Client looks like this: Host: SQLServerInstancename Instance: Default SQL Server version: 2008 R2 Security: Mixed Host type: virtual Userid: sa password: sapassword and this is our backup script: OPERATION BACKUP DATABASE $ALL SQLHOST "SQLServerInstancename" NBSERVER "BackupServername" MAXTRANSFERSIZE 6 BLOCKSIZE 7 POLICY Onsite_SQL-Cluster_Database BROWSECLIENT "SQLServerClusterName" NUMBUFS 2 VERIFYOPTION STOPONERROR ENDOPER TRUE My question is this: I know I can go to any server and configure the Netbackup client and pull up the Databases available for restore on the clustered instance. What I am struggling with is pulling up the list using BPLIST so that I can then use BPRESTORE to do a redirected restore. for BPLIST I have tried the following: C:\Program Files\Veritas\NetBackup\bin>bplist -C SQLServerInstancename -t 15 -S BackupServername -k Onsite_SQL-Cluster_Database -s 06/07/2015 0:00:00 -e 6/12/2015 00:00:00 and C:\Program Files\Veritas\NetBackup\bin>bplist -C SQLServerClusterName -t 15 -S BackupServername -k Onsite_SQL-Cluster_Database -s 06/07/2015 0:00:00 -e 6/12/2015 00:00:00 and each time I got this error: EXIT STATUS 227: no entity was found Can anyone help? I'm sure I just have a syntax error or maybe a missing parameter? +---------------------------------------------------------------------- |This was sent by [email protected]<mailto:[email protected]> via Backup Central. |Forward SPAM to [email protected]<mailto:[email protected]>. +---------------------------------------------------------------------- _______________________________________________ Veritas-bu maillist - [email protected]<mailto:[email protected]> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - [email protected]<mailto:[email protected]> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -- Ron Jack Systems Administrator • McClatchy IT 215 S. McDowell St. - Raleigh NC 27601 Office: 919.829.4769<tel:919.829.4850> | Fax: 919.829.5792<tel:919.829.5792> www.mcclatchy.com<http://www.mcclatchy.com/>
_______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
