RE: Replacing a crashed Culster -
12-22-2003
, 11:52 AM
If you've saved a copy of all the MDF's and LDF's then you could replace
them with the original files from a new install. If you don't have SQL
backups or copies of these files, then there won't be anything to recover.
If you have backups of the user databases but not master, then you'll
likely run into problems with logins. The following SQL articles will help
you there.
SQL Article to read:
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
307775 INF: Disaster Recovery Articles for Microsoft SQL Server
http://support.microsoft.com/?id=307775
The most common mistakes in Cluster configuration are covered in the
following two articles.
Cluster Articles to read:
254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321
258750 Recommended Private "Heartbeat" Configuration on a Cluster Server
http://support.microsoft.com/?id=258750
259267 Microsoft Cluster Service Installation Resources
http://support.microsoft.com/?id=259267
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights. |