07-06-2011 01:40 AM
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?
Solved! Go to Solution.
07-06-2011 02:27 AM
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
07-06-2011 02:01 AM
Do you have remote agent install on the SQL server ?
07-06-2011 02:13 AM
Yes. Certainly. On active node I have.
On passive I doesn't have it. But I can install it if it nessasary.
07-06-2011 02:27 AM
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
07-06-2011 11:12 PM
The reason was not enough space for restore database.
All work!