Forum Discussion

ghani01's avatar
ghani01
Level 3
10 years ago

Restore SQL cluster Database

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) o...
7.6
Backup and Recovery
Best Practice
Configuring
Enterprise Backup and Recovery
NetBackup
Restore
System Recovery Disk
Troubleshooting
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    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.

ghani01's avatar
ghani01
Level 3
10 years ago

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...