Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

System Database Moves

1
August 27, 2009  3:30 PM

Moving System Databases in MSSQL2005



Posted by: Colin Smith
MS SQL, MS SQL Server, SQL Server Administration, System Database Moves

Recently I had to move all system databases for one server to another physical drive. This is pretty simple for all but the Master and SystemRecource databases. For all others you can just do the following and then copy the mdf and ldf files to the new location.

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1