I haven't looked recently but if the redirected restore or process to list images and do the recovery isn't in the latest SQL admin guide take a look in the 6.0 or 6.5 manual. I guarantee its there.
Sent from my mobile > On Jul 15, 2015, at 4:03 PM, Lightner, Jeff <[email protected]> wrote: > > 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]> > 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]> > To: [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] via Backup Central. > |Forward SPAM to [email protected]. > +---------------------------------------------------------------------- > > > _______________________________________________ > Veritas-bu maillist - [email protected] > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu > > _______________________________________________ > Veritas-bu maillist - [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 | Fax: 919.829.5792 > www.mcclatchy.com > _______________________________________________ > Veritas-bu maillist - [email protected] > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
