Monday, February 20, 2012

Moving master database in cluster

Hi
We have SQL 2000 Ent in cluster mode, we move the database in to different
drive and log in to different drive. but now we want to move All the
database (the default one also, which is master, tempdb, etc). (its mainly
for backup purpose, otherwise SAN not supporting)
Ok in this case, how to do that? just stop the sql service and move the
database? it will be fine? or any idea?
Regards
GopiGopi
See this from Microsoft Support pages:-
"How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server" - it gives the details on what to do
with master, msdb, model and tempdb.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3134121122120121120120
Steve|||You move them exactly the same way as you would on a standalone machine.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:e%23HoFYxKGHA.964@.tk2msftngp13.phx.gbl...
> Hi
> We have SQL 2000 Ent in cluster mode, we move the database in to different
> drive and log in to different drive. but now we want to move All the
> database (the default one also, which is master, tempdb, etc). (its mainly
> for backup purpose, otherwise SAN not supporting)
> Ok in this case, how to do that? just stop the sql service and move the
> database? it will be fine? or any idea?
> Regards
> Gopi
>

No comments:

Post a Comment