dbTalk Databases Forums  

Replacing a crashed Culster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Replacing a crashed Culster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fredrik
 
Posts: n/a

Default Replacing a crashed Culster - 12-20-2003 , 09:53 AM






Hey

Just wondering if there is something specail to have in
mind.

I will install the cluster from the beginning and then
transfer the database-files. Could this go wrong? and
what?

As a have understod this would only cause one problem,
the bulid in administrator?

Would bee nice if somone could comments little about
this...

/Fredrik

Reply With Quote
  #2  
Old   
Kevin McDonnell [MSFT]
 
Posts: n/a

Default 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.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.