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)
 moving DB files from 1 location to another

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-04-15 : 03:13:23
is it possible to move the datavase file and its log file to another
folder on the SERVER HD
withought makeing deattch/attach (maybe using code)?

thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-15 : 14:11:11
Use 'alter database', but still need move files and restart sql.
Go to Top of Page
   

- Advertisement -