January 29, 2007 at 2:27 am
Testdb.mdf database is in f:\database and it is attached to my sql 2000 server , if i want change the database from f:\database directory
to d:\database\Testdb.mdf and log files and remove database from f:\database\Testdb.mdf and log files.
SURESH
January 29, 2007 at 4:27 am
January 29, 2007 at 7:28 am
January 29, 2007 at 8:13 am
detach ur database copy the file to ur new loaction and then attach ur database to the sql server. this would do for u.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy