We help IT Professionals succeed at work.
Get Started

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

190 Views
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,
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE