Hey guys,

I'm struggling with this somewhat, mainly because I've never really played around with WSS nor databases very much (yes, it's embarrassing to admit it, but I'm working on rectifying it).

However, I've got a small problem whereby I need to migrate the WSS content databases off C:\ and onto D:\, but despite following all the steps detailed on Ian Morrish's blog (www.wssdemo.com), but I'm still not getting anywhere..

If anyone has any idea about this, or has successfully done a WSS migration, please give me a yell. I'm supposed to do this on a production environment this afternoon. If necessary, we can hold off, but if so, I'm going to look like an idiot in front of my boss (still preferable to f***ing up a client's database).

Cheers,
Ges

http://www.microsoft.com/technet/windowsserver/sharepoint/V2/movewsdb.mspx

is that what u want to do?

btw this is a great site
http://www.smallbizserver.net/tabid/53/Default.aspx


last edited by TiT at 11:40:51 26/Oct/07

I'd be suggesting that your boss is the idiot if he wants something done in production that you've not tested on the bench. You should atleast try this once as a test before going live. I've done it once following Microsofts guide but that was a non live environment, absolutely standard everything. It went without a hitch. Test it first, a couple of days delay is better than dropping the system.

hey guys, thanks for the input.

My boss didn't want it tested live, but the go-live was supposed to be this afternoon. I actually fired up an SBS test server on my laptop and have been playing around in there.

I finally got it to work.. the problem was a syntax error in the command lines.. Given that I know nothing about SQL, I was trusting the instructions implicitly, and there just happened to be a missing ' which caused my command to fail.

All sorted out now, go-live is stil scheduled for this afternoon and my test box is running along quite happily on its newly migrated databases :)

Cheers,
Ges.