SQL 2005 + SP3: Need to Move System DBs for SharePoint 2007
Posted on 2010-01-13
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,