cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL Failover Cluster Database

Achilles1
Level 4

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?

1 ACCEPTED SOLUTION

Accepted Solutions

RahulG
Level 6
Employee

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

View solution in original post

4 REPLIES 4

RahulG
Level 6
Employee

Do you have remote agent install on the SQL server ?

Achilles1
Level 4

Yes. Certainly. On active node I have.

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

RahulG
Level 6
Employee

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
Level 4

The reason was not enough space for restore database.

All work!