Veritas-bu

[Veritas-bu] Using BPLIST and BPRESTORE on Windows

2015-07-15 12:52:12
Subject: [Veritas-bu] Using BPLIST and BPRESTORE on Windows
From: itsonlyme4 <nbu-forum AT backupcentral DOT com>
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Date: Mon, 13 Jul 2015 11:55:09 -0700
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 janice.richardson AT kofc DOT org via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread] Current Thread [Next in Thread>