|
Home > Archive > MS SQL Server > February 2006 > Moving master database in cluster
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
Gopi
| |
|
| Gopi
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/defaul...122120121120120
Steve
| |
| Michael Hotek 2006-02-06, 1:23 pm |
| 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
>
|
|
|
|
|