Re: Cluster DR

From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
Date: Tue, 17 Jan 2006 17:01:37 -0500

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" <bukusu@xxxxxxxxx> wrote in message
news:el5gBC7GGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>

.

References:
- Cluster DR
  - From: John Smith

Prev by Date: Re: Cluster Upgrade
Next by Date: Re: MSSQL2K and MSSQL side by side in clustered environment
Previous by thread: Cluster DR
Index(es):
- Date
- Thread

Relevant Pages

Re: Cluster will not fail over.
... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
(microsoft.public.sqlserver.clustering)
XPe SQL Database Backup/Restore
... This is a general FYI to anyone having difficulty with restoring the XP ... Embedded Component Database. ... Microsoft SQL Server Management Studio Express ...
(microsoft.public.windowsxp.embedded)
Re: Cluster will not fail over.
... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
(microsoft.public.sqlserver.clustering)
Re: Cluster will not fail over.
... This worked bringing up the sql server in minimal mode. ... > Start SQL Server in single user mode with trace flag -T3608. ... > SQL from recovering anything except the master database. ... > You didn't mention whether you blew the cluster away or not or just ...
(microsoft.public.sqlserver.clustering)
Re: Migrate existing standalone to cluster
... To create a database with a case-sensitive collation, ... Finally, remove the standalone. ... Columnist, SQL Server Professional ... >> the DB's to the cluster? ...
(microsoft.public.sqlserver.clustering)