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

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...b;en-us;307775

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:

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/de...kprst_4g4w.asp

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

HTH
Andreas


"Carlos Eduardo Selonke de Souza" wrote: