Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Database server migration

  Asked By: Beth    Date: Jan 09    Category: Sharepoint    Views: 1021

I need to migrate my site from one server to another.

I can do it successfully.

However I also need to move my database from an existing server to the
other one.

Can anyone please tell me how should I connect the site to this new
database server and remove the string to the old server....???

And yes im using WSS2003.



5 Answers Found

Answer #1    Answered By: Jagdish Joshi     Answered On: Jan 09

Would anyone be please kind enough to answer my query.....??

Answer #2    Answered By: Shara Johnson     Answered On: Jan 09

Moving the Content Databases is easy. Just remove  them from WSS, move
them to the new DB and read them. The Config DB is a little trickier.
If I had to guess, I'd guess you could remove the Content DBs from WSS,
unextend WSS from the Virtual Server, move  the Config DB to the new
server, reextend WSS to the Virtual server  and point it at the existing
Config DB. Then add your Content DBs back in. I've never done the
Config DB part myself, but I would think it would work.

Answer #3    Answered By: Christop Mcfadden     Answered On: Jan 09

The mindsharp.com web site  has a premium content area that has a white
paper on how to move  databases for SharePoint from one SQL server  to

Answer #4    Answered By: Cassidy Sharpe     Answered On: Jan 09

Just Take the SPSBakuputility backup and Restore it to New server  farm
It will Automatically create the all the databse including config databse
with original settings..

It will overwrite the original config databse.
I Tested this .

Answer #5    Answered By: Damon Garner     Answered On: Jan 09

Don't worry about restoring the configuration database, as you create
your new server, or new server  farm, just create a new configuration
database on the new database  server. Then if you did an STSADM backup,
just restore it to the new farm (Server(s)). If you did a database
backup, restore it to the new SQL server, and use Central admin to
extend the site  and point it to your database. You may have to extend
the site allowing it to create a new content database, and then add your
content database to the site. You can then remove  the temporary content

Didn't find what you were looking for? Find more on Database server migration Or get search suggestion and latest updates.