SQL Server TechCenter >
SQL Server Forums
>
SQL Server Disaster Recovery and Availability
>
SQL 2008 Cluster Data recovery
SQL 2008 Cluster Data recovery
- Hi Guys,I had a major power spike in our DC and it took out our SAN's with VM environment on it and im in need of some advice.we had a 3Node SQL 2K8 Cluster that stored our SCCM and OCS DB's on an external LUNI now have no SQLCluster and am currently rebuilding this.I am wondering how i can go about importing the actual database back into the new Cluster when i have only got the raw files from Data\RPT_SCCM.* ?? any ideas?thanks
Answers
- Hi Jamitupya
Ideally, you would remove the SP, attach the files as above, then re-install the SP.
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/5b1fc724-00fa-49b9-acd3-1e3a183444ec
Ewan
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).
If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.- Marked As Answer byJamitupya Tuesday, October 27, 2009 12:06 AM
All Replies
- Hi Jamitupya
If the new build is identical (same version and SP level, installed on same paths/drives, you can simply copy the raw data files into your new DATA directory (move the newly installed system databases somewhere safe in the meantime.
So build your new SQL cluster, take SQL Resource offline, and copy the files. Then bring the SQL Resource back online - provided the power spike didn't cause data corruption in your raw data files (very possible - you should do a CHECKDB on those databases) you should be good to go.
Failing this, you will need to restore from backup.
HTH
Ewan
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).
If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.- Proposed As Answer byJoukoK Friday, October 23, 2009 7:24 PM
- Thanks Ewan, will give it a go monday, the system is a LAB mainly so not a big issue on the restore from backup. Mainly trying to figure out how to do it for future :-)thanks heaps.
- Hi Jamitupya
No problem.
Just to be clear - you'll need to copy all of the database files (including system databases) not just the SCCM files.
Regards
Ewan
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).
If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution. - Hi Ewan,Thanks for the instructions and yes i guessed that however it appears when i check version histories the old cluster was only 2008 (no SP1) and the new is SP1...do you have any ideas for this scenario?Thanks
- Hi Jamitupya
Ideally, you would remove the SP, attach the files as above, then re-install the SP.
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/5b1fc724-00fa-49b9-acd3-1e3a183444ec
Ewan
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).
If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.- Marked As Answer byJamitupya Tuesday, October 27, 2009 12:06 AM
- Got it, thanks heaps Ewan, combination of fixes.was able to remove update apply Databases, run checkdb, update, then rebuild indexes for apps.Thanks a bunch mate.
