MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Moving MOSS 2007 databases

  Asked By: Marcus    Date: Dec 01    Category: MOSS    Views: 1041

I'm having some frustrations trying to move the databases from MOSS 2007
from their default location on the C: drive to a considerably more
spacious D: drive.

I've stopped the Content database in the configuration tool and tried to
DETACH it with the SQL command line client but it keeps giving me an
error that the database is in use.

I tried using the ATTACH DATABASE...SINGLE_USER... trick but that fails
with a syntax error that I suspect is caused by the fact that the
database name has hyphens in it.

Anybody have any guidance? I can't believe it's this hard to just move
the disk location of the databases. You can move Exchange's databases
using the GUI in about 60 seconds.



5 Answers Found

Answer #1    Answered By: Parijat Pathak     Answered On: Dec 01

Stopping the database in Central Admin doesn't do what you think it
does. Stopping a database means that no newly created Site Collections
will not go in there. It continues to serve up content. To do what you
want you need to click the database and check "remove content database."
This will detach it from SharePoint. Then you can move it in SQL.
After it's moved in SQL you go back into Central Admin and add the
database back in again.

Answer #2    Answered By: Ella Sargent     Answered On: Dec 01

Well, I did the "remove content database" option but it still says the
database is in use when I try to Detach it. Any other ideas?

Answer #3    Answered By: Ahmad Johns     Answered On: Dec 01

...I'm getting MSG 3703, Level 16, State 2 if that helps at all.

Answer #4    Answered By: Roxanna Hendricks     Answered On: Dec 01

You didn't say, but I assume you're using SQL 2005 Express. If so, you
might want to install the management studio for it from

That'll give you the regular SQL management studio interface including
the activity monitor. You might be able to figure out what's using that
database that way.

Answer #5    Answered By: Stacia Guy     Answered On: Dec 01

Yes, 2005 Express. I’ll try the management studio.

Didn't find what you were looking for? Find more on Moving MOSS 2007 databases Or get search suggestion and latest updates.