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)
 Instance Running db on System Drive

Author  Topic 

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2004-10-25 : 17:27:55
I need to move a database from a second instance to my data drive...
Is this as simple as detaching the db, and copying it to the new location and recopying it...

I also need to move the tempdb for this instance to my data drive any suggestions?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-25 : 18:10:19
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Tara
Go to Top of Page

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2004-10-25 : 18:36:05
Thank you!

Go to Top of Page
   

- Advertisement -