Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Moving MOSS 2007 databases

Asked By: Marcus Peterson Date: Dec 01, 2008 Category: MOSS Views: 253

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.

Tagged:moving moss 2007 databases

5 Answers Found

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

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, 2008

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, 2008

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

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

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
www.microsoft.com/.../details.aspx
E3D-94B8-5A0F62BF7796&displaylang=en

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, 2008

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.