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: 01SQLSRV01 (Passive)

When I restore SQL Database I point  the sql server cluster name (screenshot1)

After I add depending (screenshot2) the name "01SQLCL01" and start the Job start,

but didn't do "0 byte", after 20 minutes I get  e000fe30 V-79-57344-65072 
 

What the specials features I must take into account when I restore SQl database on SQL Failover Cluster?

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

4 Replies

Sort By
  • 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

  • Achilles1's avatar
    Achilles1
    Level 4
    14 years ago

    Yes. Certainly. On active node I have.

    On passive I doesn't have it. But I can install it if it nessasary.