Moving System Databases in SQL Server for ConfigMgr

Have you ever had to move any of the following system databases: master, tempdb and/or msdb to another location?

Be sure that you have a recent backup (use the backup task, which gives you all the information needed for recovery) for ConfigMgr.

You'll want to check the online reference for step by step instructions:

This topic describes how to move system databases in SQL Server. Moving system databases may be useful in the following situations:

  • Failure recovery. For example, the database is in suspect mode or has shut down because of a hardware failure.
  • Planned relocation.
  • Relocation for scheduled disk maintenance

http://msdn.microsoft.com/en-us/library/ms345408.aspx

Published Monday, January 26, 2009 4:26 PM by sthompson

Comments

No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems