move DB location

[elibb]

hi, i have SQL Server 7.0 and SQL Server 2000, and i have it installed in my had drive c:, and all the databases are in the default directory, but im running out of space in c: and id like to know if there is a way to move the database to another location (in e: for example) without having to create another database and import all the contents.. id like to avoid that

thank you very much

Eli

 

[JayKusch]

PLEASE DO NOT CROSS POST TO DIFFERENT FORUMS !!!

Thanks

J. Kusch

 

[MDXer]

Fastest and easiest would be to detach the db move the .mdf and .ldf files to the new location then reattach.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck