Moving System Databases - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » Moving System Databases

Moving System Databases

Options

Previous Topic · Next Topic

muchmoishe

Posted: Monday, March 03, 2008 2:49:55 PM

Rank: Newbie

Joined: 8/29/2007
Posts: 3
Points: 12

My SAN administrator has asked me to move all of the system databases and user databases on our SQL Server 2000 servers as a part of a SAN reallocation. I've moved user databases, but I'm not so sure about moving master, model, msdb, tempdb, and distribution.

I have two questions:

1) Is it possible to do so and, if so, 2) What is involved in making such a move (especially moving the 'master' database)?

Best Regards,
Moishe

Scott Whigham

Posted: Friday, March 07, 2008 7:37:16 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

1) Yes

2) I recorded a video on it actually: [url http://www.learnsqlserver.com/VideoTutorials/Sql-Server-Video/1218/How-to-Change-Master-Database-s-File-Locations.aspx]How to change the master database's file location[/url]

To move the other dbs, read http://support.microsoft.com/kb/224071

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.