Tuesday, February 05, 2008

Move SQL 2005 system databases

Good article at http://www.sqlservercentral.com/articles/Administration/2605/# By Vince Iacoboni, 2006/09/26 with script. Just one problem you need to disconnect your SQL server from the newtwork and stop all additional SQL services as Reporting, Analysis, Search and so on, and stop WWW service. All of this should be done in order the script will be able to put SQL server in single user mode and move mssqlsystemresource database.

No comments:

Post a Comment