dbTalk Databases Forums  

Restoring My Database

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Restoring My Database in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Tom Moreau
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.