Recently I had to create a SharePoint essentials Disaster Recovery server. Basically this involved taking a backup of the SharePoint content database and restoring it to another SharePoint server using a different application name (Website name). This would be useful if you were moving SharePoint or sometime similar! Anyway here’s how I did it:
Log on to your current SharePoint server,
Open Microsoft SQL Server Management Studio,
Find the Content Database, often called “WSS_Content”
Right click > Tasks > Back Up >
Add a file store or drive and click ok!
Once backed up, copy the file to your new (DR) SharePoint server.
Log on to the DR Server
Open the “SharePoint 2010 Central Administration” page
Open Manage Web Applications:
Select the default SharePoint site that has a port of 80 and click Delete:
Delete both the IIS settings and the Content Database:
Open Microsoft SQL Server Management Studio and logon using your Admin logon.
Drop down “SharePoint” and right click “Databases” and click “Restore Databases”
You should see the below, add a unique name starting with WSS_Content_and add the SQL backup from your backup folder.
Tick the box next to name and click ok and wait (will take a while)!!!
Once done, you should see it in the list of Databases.
Drop Security (Under the Databases section) and Add a new user with permissions on the database (I’ve been lazy and used SA as a user, best not do this):
Now its restored and a user has permissions to access it, go back to the SharePoint Administration and Manage Web Applications.
Click New and fill in the details specifying the Database you have just added
Add a Useful name here and a host header (host header is how you browse to site so below would be http://wprintranet):
Check Application Pool section, You will have to Register a new Managed Account that has permissions on the Database you just added (I.e. add the new user you just added to the database).
Specify the SQL server and the NEW DB name you just added above.
Once added successfully then reboot the server and test.
Job Done! 🙂