SharePoint – Setting up a new production server by restoring the Content database

I had a requirement in which I had to build a new SharePoint server and migrate the current data to the new server. The current production server ran into many system level issue and the company who setup the server couldn’t be approached. After nailing down almost all the major issues which included lot of registry repairs and permission, FIM configuration, account setups and permissions, services configuration etc., the server was still facing issues and its behavior was intermittent which then finally claimed for the new server build J

After setting up the new server taking care of Microsoft best practices and recommendations it was time to migrate data!

Fair and simple approach:

  • Get the site collection backup from current production site
  • Restore it into new production having all the configuration same as old server

And this didn’t work :)

Setting up a new production server by restoring the Content database

I tried to resolve the issue but it was taking time and didn’t get any promising solution at first attempt so the second option was to move the content database from old server to new.

The old version was SharePoint Server Enterprise and new server setup was SharePoint Server Enterprise SP1

Steps followed on new server:

Step 1: Backup the content database from old server and restore it in new server

Step 2: Create a web application on specific port (don’t create site collection)

Step 3: go to Application Management-> Manage content databases

Setting up a new production server by restoring the Content database

Setting up a new production server by restoring the Content database

Remove the current content database by clicking on it and check the “Remove content database” and then add the content database and set the same name of the restored content DB.

Setting up a new production server by restoring the Content database

Now just hit the URL, it should be working!

Setting up a new production server by restoring the Content database

PS Command: Upgrade-SPContentDatabase <WSS_Content>

Upgrades the existing <WSS_Content> content database schema and then performs only build-to-build upgrade actions on existing site collections if required. This operation does not changed the CompatibilityLevel for existing site collections in this database.

Setting up a new production server by restoring the Content database

Setting up a new production server by restoring the Content database

The error is gone!

The following two tabs change content below.
Muhammad Sami Ahmed

Muhammad Sami Ahmed

With over 9 years of extensive working experience on different projects and products in SharePoint server, ASP.NET, C#, WCF, WPF, LINQ, SQL Server. He is working on SharePoint for past five years. He is skilled and proficient in systems architectural design and development of complex SharePoint web applications. The development background gives him an edge in designing the end solution to exploit the full capabilities of SharePoint.

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *