Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Moving databases

  Asked By: Angelique    Date: Mar 19    Category: Sharepoint    Views: 713

There are several articles on moving databases from one server to
another by doing a backup, uninstall, reinstall and restore. However,
that is real clunky and doesn't preserve settings!
I want to move my SharePoint databases from SQL 2005 server B to SQL
server B. According to the Microsoft article: "Using SQL Server
Database Mirroring with Office SharePoint Server and Windows SharePoint
Services" the first thing I do to accomplish the config db move is to
execute the command: stsadm.exe -o renameserver -oldservername
<OldPrincipalServer> -newservername <NewPrincipalServer>. However
after doing this and rebooting the server I was no longer able to
attach to config DB! Any suggestions?

Share: 

 

No Answers Found. Be the First, To Post Answer.

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




Tagged: