Moving a SharePoint DB

[MasterRacker]

One more preparatory question before I botch my first MOSS install and have to start over. ;-)

Assuming I had a working farm with all functions installed on server named "SPServer" and all databases on a SQL Server named "SPDBTest". How difficult would it be to later move all databases to a different server named "SPDBProd", leaving everything else the same, simply pointing the applications to the new DB server?.

I'm hoping MOSS is designed for this type of thing for disaster recovery if nothing else, but I'm looking for input from someone who has working experience. Thanks.



_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[fh786]

Some useful info on these sites:

http://msmvps.com/blogs/cgross/archive/2007/03/24/moving-your-wss-3-0-databases.aspx

http://www.alpesh.nakars.com/blog/wssv3-on-a-dc-4/

 

[MasterRacker]

Thanks. That's pretty straightforward, unfortunately I don't think those cover the full process since they're only talking about Sharepoint Services. There's nothing about repointing MOSS server farm applications to the new server.

I'm sure it's not that difficult. Moving DBs around is something any medium to large shop does on a regular basis.

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]