December 4, 2007 at 3:14 pm
What is the best way to move the three System databases from the default location to another disk on the same server? I know I cannot detach the system databases and move them in the same manner as user db's. Any help will be greatly appreciated. Thanks!
Ken
December 4, 2007 at 4:05 pm
backup source db's
start target sql in single user mode
open a session and retore these db's one by one, master,msdb,model
restart sql server normal....
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
December 4, 2007 at 4:08 pm
here's the process..easy google search
http://www.sqlservercentral.com/articles/Administration/2605/
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
December 6, 2007 at 9:44 am
Thanks for all your help!
December 7, 2007 at 6:59 am
Due to the nature of the system databases, there are extra steps involved in moving them.
--
The following Microsoft Knowledge Base Article will work for SQL 7.0, 2000, and 2005 respectively.
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
http://support.microsoft.com/kb/224071
--
See September 2007 SQL Server 2005 BOL or the MSDN online Article:
Moving System Databases (SQL Server 2005)
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
--
Happy T-SQLing!
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply