RE: Backup and Restore of the Cluster

Hi Carlos,

If you don't have a different instance name, the things that you have to do
are to create your logins to the new server with a DTS Package and after
restoring all your databases, except master, msdb, execute the
sp_change_users_login (Ref. BOL) to assign the roles. Then you will be ready
to check and follow the article below.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp

Please, use them first in a test environment if applicable.

HTH
Andreas


"Carlos Eduardo Selonke de Souza" wrote:

> 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: test environment windows 2003
    ... an authorative restore after the demote and system state restore. ... Remove the physical cable for the new pc and build the member server ... At a command prompt type in NTBACKUP and do a system state backup saving ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Exchange Server Restore From Backup - Help Needed
    ... had to modify the backup so that the Exchange Server files were only ... when I come to do a restore the only option I ... get is to restore to the current machine or to another Exchange Server. ... Because the Travan Tape only holds 20GB uncompressed 40GB compressed, ...
    (microsoft.public.windows.server.sbs)
  • Re: Disaster Recovery with NTBackup
    ... Windows Update may ... Win2K3 SP1 only (if not integrated into your SBS CD) ... Restore the backup using the document from the link I mentioned ... size equal to greater than the original server). ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange Server Restore From Backup - Help Needed
    ... Set the database settings for public folders and information store to ... you would want to be careful not to restore the files from the tape ... overwrites/stuffs up my Exchange server as I do use that for collecting ...
    (microsoft.public.windows.server.sbs)
  • Re: backup solution for sbs?
    ... Restoring Your Server ... you can restore to the same computer or you can restore to new hardware. ... Before restoring your server, disconnect any external disk drives, such ... restore your server from the latest successful backup. ...
    (microsoft.public.windows.server.sbs)
Loading