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.

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: