RE: Backup and Restore of the Cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Andreas

Thanks for you repply but Im looking for information about backup and
restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
Server.

I am most interessed in how to restore the master and msdb database on the
new virtual server, since the user databases is pretty easy.

--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org


"Andreas Mavrogenis" wrote:

> Carlos hi,
>
> You will find plenty of information in BOL. Search by planning for disaster
> recovery
> Also, read the following article and it's links
> http://support.microsoft.com/default.aspx?scid=kb;en-us;307775
>
> HTH
> Andreas
>
> "Carlos Eduardo Selonke de Souza" wrote:
>
> > Hello
> >
> > I want backup my SQL Server Cluster (two nodes) and to restore it on other
> > two nodes on another site.
> > I need to know that procedure to test my DRP. I know that the best would to
> > have a geocluster but for now (budget limitations) I just want to be able to
> > restore the cluster.
> >
> > I would like your help to point me documentation about how to do this
> > procedure or if someone has any experience about I would be glad to know.
> >
> > Thanks in advance.
> > --
> > Carlos Eduardo Selonke de Souza
> > http://carlos.geekbunker.org
.

Relevant Pages

  • Re: Cannot restore databae successfully
    ... On your new cluster, you have not made drive E: a dependency for SQL Server. ... Restore your DB ...
    (microsoft.public.sqlserver.clustering)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... current install and the Virutual SQL Server will be a default instance. ... >> outside world IS the Virtual SQL Instance name. ... Again, copying the system databases, even if successful, won't fix ... >>> You may want to build a test cluster using cheap recycled SCSI hardware ...
    (microsoft.public.sqlserver.clustering)
  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • 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)