Monday, February 13, 2012

How to Migrate a SharePoint 2010 MSSQL 2008 instance to another instance or server

The context:
  • One server with SharePoint
  • A SQL Express2008 R2 UK instance (without SharePoint)
  • A SQL Express2008 FR instance for SharePoint (not  R2)


My Problem:
  • Wanted to upgrade the Express2008 FR instance to R2 SP1, but got an error message "SQL Server setup media does not support the language of the OS or does not have ENU localized files. Use the matching language-specific SQL Server media or change the OS locale through Control Panel."
  • I tried the work aounds founds on the web (regional settings, etc...), but the error was still there

Work around:

I decided to install a new SQL instance on the server and then use it for my SharePoint, here are the steps :

  • Backup all your SharePoint databases
  • Run the MSSQL 2008 Express R2 SP1 exe, this action create a new SQL instance (I named it "SharePoint2")
  •  Restore the backups in your new instance ("SharePoint2"), don't forget to change the physical location of your MDF and LOGS files
  • Create an alias to allow SharePoint to communicate with the new instance without changing any parameter in SharePoint. Pay attention, you should create 2 alias (32 and 64 bits) and activate the TCP/Ip protocol in SQL

No comments:

Post a Comment