moving datafiles and log files
-
Hi
how can i move data files and log files from 'c' drive to 'd' drive where all the system database and user defined database are created in the 'c' drive.
please suggest me
-
detach your database and then move ur files to ur new loaction and then again attach ur database.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
This won't work for system databases or if your database is published for replication.
For replicated databases the easiest workaround is to back it up and restore to the new location using the WITH MOVE option. For system databases, see the following:
http://support.microsoft.com/kb/224071
John
-
yes u can't detach and attach ur system databases. i dint read that the user wants to move the system databases too.
u can do the following
1. stop the sql server service
2. copy the database files to new loaction
3. then change the sql server startup parameters to reflect ur new location
4. also add the following in the startup parameters -T3608 so that only your master database is recovered at startup
5. then start ur sql service
6. once ur service is up and running
7. remove the switch -T3608 and allow the service to startup normally.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
These should help - describes how to move master, tempdb and msdb.
http://www.databasejournal.com/features/mssql/article.php/3379901
http://support.microsoft.com/kb/224071
Cheers
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply