Forum Discussion

Achilles1's avatar
Achilles1
Level 4
14 years ago

Restore SQL Failover Cluster Database

Hallo. I have BackupExec 13 (2010) jn Windows 2003 SP2 R2. I try to restore SQL database on SQL Failover Cluster. SQL Cluster Server name: 01SQLCL01 One node: 01SQLSRV02 (Active) Two node: ...
2010
Backing Up
Backup and Recovery
Backup Exec
Recovering
Restore
  • RahulG's avatar
    RahulG
    14 years ago

    You can follow the steps below

    1.Create a new database.
    2.Put it in single user mode
    3.In the restore select the following option
    4.Redirect the restore to the new database
    5.In the SQL tab select the following options
    6.Replace database or file groups
    Alternate drive for restoring databases as "x"and select the option Restore to alternate drive even if original drive exist

RahulG's avatar
RahulG
Level 6
14 years ago

You can follow the steps below

1.Create a new database.
2.Put it in single user mode
3.In the restore select the following option
4.Redirect the restore to the new database
5.In the SQL tab select the following options
6.Replace database or file groups
Alternate drive for restoring databases as "x"and select the option Restore to alternate drive even if original drive exist