06-29-2015 11:59 PM
Hi All,
I have a SQL database cluster Server ,local drive (C and D) and Present from storage LUN (J, K, and L). I already configure MS windows Backup policy with enable Bare Metal Restore (BMR) option and backup selection (ALL LOCAL DRIVE).
Let say, the server crash or can't boot windows, how can i do a BMR restore?.How i manage the drive J, K and L?..Need or not to separate backup policy for J,K and L drive.?
Environment= NetBackup 7.6.0.1, Win Server 2008/2012
Thanks
Solved! Go to Solution.
06-30-2015 02:31 AM
Correct.
You could try one windows policy (with ALL_LOCAL_DRIVES) but I've noticed that when using MSCS the drives (J, K, and L) don't get completed removed from the system when it fails over. They are not there but for some reason the drives (J, K, and L) get reported to the NetBackup client so it creates a stream for them but they end up failing with a 69 error.
06-30-2015 12:16 AM
I would create MS windows 1 policy with BMR enabled for OS drives, clients = both nodes. Then I would create a second MS windows policy for the shared drives, clients = virtual name. And then obviously a third MS-SQL-Server policy for the databases, clients = virtual name
06-30-2015 12:27 AM
thanks Riaan,
but how to define in backup policy the shared drives?
06-30-2015 12:44 AM
J:\
K:\
L:\
You can add new stream in between them if you require multistreaming.
Make sure the client name is set to the virtual name of SQL.
06-30-2015 01:16 AM
Hi Riaan,
That means for 1 cluster DB need to do:
1-MS windows backup policy with BMR enable.(local drive)
2-MS windows backup policy (shared drive)
3- MS-SQL backup Policy.
Correct me if i am wrong....
thanks a lot...
06-30-2015 02:31 AM
Correct.
You could try one windows policy (with ALL_LOCAL_DRIVES) but I've noticed that when using MSCS the drives (J, K, and L) don't get completed removed from the system when it fails over. They are not there but for some reason the drives (J, K, and L) get reported to the NetBackup client so it creates a stream for them but they end up failing with a 69 error.