Wednesday 18 June 2014

SharePoint 2010 restore content DB

1. Restore wss_content_sharepoint_8080 to SQL Server.
2. Create test WebAppliation on port 8082 with its own content db (wss_content_sharepoint_8082).
3. Create site collectino in web applicatino on port 8082. Verify that site opens.
4. Now delete the content DB wss_content_sharepoint_8082.
5. Run STSADM command to restore the DB (wss_content_sharepoint_8080)
PS C:\> stsadm -o addcontentdb -url http://SP2010:8082 -databasename wss_content_sharepoint_8080 -databaseserver yoursqlserver
6 Run IIS RESTART from command prompt.