Re: Restoring My Database -
03-03-2008
, 07:47 AM
Don't think of it as restoring on a node. Your client tool talks to the
virtual instance. The instance has data disks associated with it. You
restore the DB via the instance and tell it which disks to use. It doesn't
matter which node is running the instance.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Leila" <Leilas (AT) hotpop (DOT) com> wrote
Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers? How
is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila |