Home > SharePoint 2010, SharePoint 2010 Maintenance, SharePoint Administration > Migrating SharePoint 2007/2010 Databases to New SQL Server/Cluster Without Having to Completely Reconfigure SharePoint Utilizing SQL Alias

Migrating SharePoint 2007/2010 Databases to New SQL Server/Cluster Without Having to Completely Reconfigure SharePoint Utilizing SQL Alias

I recently had to migrate from an old SharePoint 2007 SQL Server environment to a more stable/robust SQL Server 2008 R2 environment to stabilize and increase the performance of SharePoint. I needed to do this with little to no down time. I was able to accomplish this by utilizing SQL Aliases. Below are the steps I took to accomplish this. Steps work for both MOSS 2007 and SP2010.

For this example I will be using SQL1 as the name for the “old” SQL Server Instance, and SQL2 for the “new” SQL Server Instance.

1. Stop all SharePoint services that might be communicating with SQL1 back-end. This helps to prevent any writing to the databases while they are being backed up.
2. Backup all SharePoint 2007 databases including: (Config, SSPs, Search, and Content) from SQ1.
3. Move all SharePoint 2007 databases to SQL2.
4. Restore all SharePoint 2007 databases to SQL2.

On the SharePoint 2007 Server we now need to create a SQL Alias (Host File for SQL) to tell SharePoint to point to the new SQL2 instance. What we need to do here is use the same exact name as the “old” SQL Server Instance SQL1 as the SQL Alias name. This is so to trick SharePoint into thinking it’s still utilizing the same SQL1 SQL Server Instance, which will prevent us from having to completely reconfigure the SharePoint farm.

Next log into one of the SharePoint 2007/2010 servers and bring up the SQL Server Client Network Utility tool. This comes native with Windows so nothing needs to be installed.

1. Start, Run, Type – cliconfg
2. Select the Alias tab and click the Add… button
3. Enter in the Server Alias (This will be the name of your “old” SQL Server Instance – SQL1)
4. Select the TCP/IP radio button under Network Libraries
5. Enter in the new SQL Server name (SQL2) for the Server Name under Connection Parameters
6.  Click “Ok” and “Ok” to close out of the cliconfg window.
6. Restart all SharePoint 2007 Services.
7. Do an IISreset on WFE Servers.

Browse to your SharePoint environment to verify portal functionality.

That’s it pretty simple.

Advertisements
  1. Amp
    August 21, 2014 at 1:51 pm

    Hi,

    I was able to follow your steps and migrate my sharepoint site. Only issue I am having is with my search now. it is coming up with a error “The search request was unable to connect to the Search Service”. Do you have any advice?

    thanks

    • August 22, 2014 at 8:06 am

      Hi Amp,

      I’m assuming you stopped / restarted the Search Service? Is this MOSS 2007 or SP2010?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: