Discussion:
[Veritas-bu] Using BPLIST and BPRESTORE on Windows
itsonlyme4
2015-07-13 18:55:09 UTC
Permalink
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 ***@kofc.org via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Patrick
2015-07-15 19:20:28 UTC
Permalink
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-***@backupcentral.com>
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Sent: 13/07/2015 19:55:09
Subject: [Veritas-bu] Using BPLIST and BPRESTORE on Windows
Post by itsonlyme4
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
Host: SQLServerInstancename
Instance: Default
SQL Server version: 2008 R2
Security: Mixed
Host type: virtual
Userid: sa
password: sapassword
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
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.
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?
+----------------------------------------------------------------------
+----------------------------------------------------------------------
_______________________________________________
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Ron Jack
2015-07-15 20:19:27 UTC
Permalink
I've always had to specify a path at the end of a bplist command. But I've
never tried it with a DB.
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 ------
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
Post by itsonlyme4
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
Host: SQLServerInstancename
Instance: Default
SQL Server version: 2008 R2
Security: Mixed
Host type: virtual
Userid: sa
password: sapassword
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
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.
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?
+----------------------------------------------------------------------
+----------------------------------------------------------------------
_______________________________________________
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
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
Lightner, Jeff
2015-07-15 21:03:49 UTC
Permalink
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: veritas-bu-***@mailman.eng.auburn.edu [mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of Ron Jack
Sent: Wednesday, July 15, 2015 4:19 PM
To: Patrick
Cc: VERITAS-***@mailman.eng.auburn.edu
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 <***@whelan-consulting.co.uk<mailto:***@whelan-consulting.co.uk>> 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" <nbu-***@backupcentral.com<mailto:nbu-***@backupcentral.com>>
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU<mailto:VERITAS-***@MAILMAN.ENG.AUBURN.EDU>
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 ***@kofc.org<mailto:***@kofc.org> via Backup Central.
|Forward SPAM to ***@backupcentral.com<mailto:***@backupcentral.com>.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu<mailto:Veritas-***@mailman.eng.auburn.edu>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu<mailto:Veritas-***@mailman.eng.auburn.edu>
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/>
Kevin Holtz
2015-07-16 00:12:40 UTC
Permalink
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
Post by Lightner, Jeff
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.
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.
Sent: Wednesday, July 15, 2015 4:19 PM
To: Patrick
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.
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 ------
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)
Host: SQLServerInstancename
Instance: Default
SQL Server version: 2008 R2
Security: Mixed
Host type: virtual
Userid: sa
password: sapassword
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
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.
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?
+----------------------------------------------------------------------
+----------------------------------------------------------------------
_______________________________________________
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
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
_______________________________________________
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Loading...