Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 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