Thursday, July 08, 2010 12:27 PM
I need to move my Moss 2007 and PWA 2007 db's to a new SQL Server
Old SQL Server: SQL 2005 x32 Std
New SQL Server: SQL 2008 R2 x64 Ent
Would it be possible to do the following.
Backup all DB's
Restore on new SQL server
Create DNS entry that points old SQL Server name to new sql server...
Would that work? We are going to upgrade to moss 2010 in the near future to do not want to waste to much time on this.
Thursday, July 08, 2010 1:44 PMModerator
Along with DNS entry create Alias for SQL server name using "cliconfg" .
This worked for me in lot of times, but the best method is Sharepoint full Farm backup and restore. You can try the "Alias" method, follow the below if that doesn't help.
Take full farm backup
Disconnect the current SQL server using SP config wizard.
Create new config db on the new SQL server using wizard.
Restore the SP farm.
Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
Thursday, July 08, 2010 11:42 PM
Just few weeks back I got a chance to perform similar activities for one of my client. I tell you its not so tough, if you got your planning done in details try to include and not to ignore Sriram points mentioned.
However you can have a quick look at this post.
Hope its helpful!
- Marked As Answer by Christophe FiessingerMicrosoft Employee, Owner Friday, July 09, 2010 3:20 AM