Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 detach/attach master safe or not?

Author  Topic 

LeoC
Starting Member

37 Posts

Posted - 2005-07-06 : 07:31:29
Given that the main DB in a SQL2K is being moved for lack of space, how or what else should you consider regarding moving the rest of the DBs; yes including 'pubs'.Is moving 'master' even wise/possible?. I guess is like a brand new installation other than is not really done (binaries still reside in the original place but that's not an issue in this case).
comments are more than welcome! especially since I'm doing this tonight.

lec.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-06 : 08:40:19
Please refer to:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
HTH

Franco
Go to Top of Page
   

- Advertisement -