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 <919.829.4850> | Fax: 919.829.5792 www.mcclatchy.com
_______________________________________________ Veritas-bu maillist - [email protected] http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
