Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cluster DR

 
   Database Forums (Home) -> Clustering RSS
Next:  Testing Error Handling for Unusual Database Error..  
Author Message
John Smith

External


Since: Jan 17, 2006
Posts: 2



(Msg. 1) Posted: Tue Jan 17, 2006 4:53 pm
Post subject: Cluster DR
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

My production cluster disks are corruptd - i would like to find out how to
restore from backups

I have all system backups and mdf and ldf files of the databases - I would
like to keep the logins, jobs etc


Thanks

 >> Stay informed about: Cluster DR 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Tue Jan 17, 2006 5:01 pm
Post subject: Re: Cluster DR [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Restoring a cluster is almost exactly the same as restoring a stand-alone
SQL Server. The only difference is that when you restire the master
database, the disks have to be online using the cluster tool, but leave the
SQL Server service offline. You then start and stop it in single-user mode
using the command-line. See BOL for details on how to restore a SQL Server.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"John Smith" wrote in message

> My production cluster disks are corruptd - i would like to find out how to
> restore from backups
>
> I have all system backups and mdf and ldf files of the databases - I would
> like to keep the logins, jobs etc
>
>
> Thanks
>

 >> Stay informed about: Cluster DR 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How SQL2005 cluster can be installed on windows cluster? - I am new on both SQL and windows cluster. Our company is trying to deploy a HA SQL system, which I need to install SQL2005 to windows cluster. My question is: Since windows cluster will share one back end storage chassis, where should I put SQL2005 on...

Cluster SDK - Can someone point me out SDK for clustering on Win2000? I am planning to invoke Cluster API's using VBS... Thanks in adv.

SQL 2005 Cluster with 2K - Hi, I have a question that I hope someone can help me with (I've trawled the net...). I want to consolidate several SS 2K databases on to a new SS 2005 2 node cluster. I will use SS 2005 standard for the cluster. Is it possible to add a 2K instance....

Doc for SQL 2000 Cluster - Hello Is there any brief howto to configure SQL 2000 Cluster on a VM? Thanks

Doc for SQL 2000 Cluster - Hello Is there any easy how to doc on installing & configuring SQL 2000 Cluster on a VM for demo? Thanks
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]