SQL 2005 + SP3: Need to Move System DBs for SharePoint 2007

Posted on 2010-01-13
Medium Priority
Last Modified: 2012-05-08
Hey everyone,

I've got a SQL 2005 (Active + Passive) Cluster Node that houses only the DB for MOSS2007.
The consultant placed the user and system DBs onto the same Lun and now were are having to clean it up.

SQL itself is installed to the C drive, but the consultant put all system and user DBs on the same Lun.  I need to move to new Luns to return some SAN space back to another department.

The drives are laid out like this:
C - SQL Program bits
D - Empty
H - Cluster Quorum
R - Consultant installed System and User DBs here.
S - New Lun that I moved User MDB files to
T - New Lun that I moved User LDF files to
U - New Lun that I plan on placing the tempDB onto.

History - I moved the user DBs by simply detaching and reattaching the copied mdb and ldf files.

Question, How do I move the master, model, msdb, and tempdb to the S and T luns respectfully so that the old S lun can be removed from the server?  There isn't a detach function for that and I'd like to be sure I understand this going into my next maintenance window.

Thanks a lot,
Question by:Team-PSO
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

ambot13 earned 1000 total points
ID: 26305298
Use this MSDN article for instructions on moving system databases:  http://msdn.microsoft.com/en-us/library/ms345408.aspx

Here is an overview of the process, and it refers to the article above, as well. http://support.microsoft.com/kb/224071

Author Comment

ID: 26305503

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question