Welcome! » Log In » Create A New Profile

Using BPLIST and BPRESTORE on Windows

Posted by itsonlyme4 
Using BPLIST and BPRESTORE on Windows
July 13, 2015 11:54AM
We are running SQL Server 2008 R2 in an ActivePassive 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 FilesVeritasNetBackupbin>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 FilesVeritasNetBackupbin>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?
Using BPLIST and BPRESTORE on Windows
July 15, 2015 12:20PM
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" <nbu-forum < at > backupcentral.com>
To: VERITAS-BU < at > MAILMAN.ENG.AUBURN.EDU
Sent: 13/07/2015 19:55:09
Subject: [Veritas-bu] Using BPLIST and BPRESTORE on Windows

[quote]We are running SQL Server 2008 R2 in an ActivePassive 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 FilesVeritasNetBackupbin>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 FilesVeritasNetBackupbin>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 janice.richardson < at > kofc.org via Backup Central.
|Forward SPAM to abuse < at > backupcentral.com.
+----------------------------------------------------------------------

_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[/quote]
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Sorry, only registered users may post in this forum.

Click here to login