03-29-2016 08:47 AM
I am looking for a method to quickly select ALL databases on an instance for restore.
This article is NOT helpful at all as it only says "You can select multiple databases when restoring database from NetBackup SQL Server Client." however it doesn't say ANYTHING on how to accomplish this.
I have read the "symantec Netbackup for Microsoft SQL Server Administrators Guide" and do not see any reference to restoring ALL Db's on a server.
*restoring to SAME server
NBU 7.6
SQL 2005, 2008 R2, 2012 & 2014
OS Windows Server 2008, 2012 R2
Solved! Go to Solution.
03-30-2016 06:49 AM
Think some scripting based on bplist will be you best bet, also because you need the names of the backup images for the restore script.
If you databases are located on a SAN, you probably can utilize the instant recovery feature based on shadow copy with the snapshot client for fast recovery.
03-30-2016 04:43 AM
Hello,
your questions can be divided into two :
- if SQL Server supports restore of multiple dbs simultaneously
- how to accomplish this with NetBackup SQL interface
Answer for first question is yes, with exception of system (master/msdb/model) databases. These databases must be restored individually and under special circumstances. Consult MS SQL documentation.
Answer to second question is that it cannot be achieved by clicking more databases in the same restore dialog window. However you can launch individual restore dialogs and restore individual databases (so restores are not simultaneously launched, but they can simultaneously run - every restore with some delay).
Regards
Michal
03-30-2016 05:59 AM
How can I request this feature?
Having a simple short method to restore an entire instance (minus system db's) would greatly decrease the time to recover. Especially if there are hundreds of databases on a server!
03-30-2016 06:49 AM
Think some scripting based on bplist will be you best bet, also because you need the names of the backup images for the restore script.
If you databases are located on a SAN, you probably can utilize the instant recovery feature based on shadow copy with the snapshot client for fast recovery.
03-30-2016 06:58 AM
Hello,
also if it is a VMware machine, you can employ VMware-based backup with "Enable SQL Recovery" option checked.
Then the restore of the whole VM machine including all MS SQL databases is a simple one step.
Michal
03-30-2016 07:24 AM
Thanks for the suggestions. I'll look into that for sure.