This week I had to do a restore of a site collection using only SQL database backup. The customers hosting partner had not setup a SharePoint farm backup and had no test environment available that we could restore the database to, so they restored the database back to the SQL server into the production environment.When …
Tag: SQL server
I think I have blogged about this before, but I cannot enough emphasize the importance of running SharePoints own backup together with your SQL database backup. Of course, some third party backup products might be able to restore in the same way as you can restore a site collection backup inside Central Admin, but it …
A while ago I got a lot of error messages in Event Viewer on our MOSS server. I found the following solution: run stsadm -o sync -DeleteOldDatabases 0 and the message disappears.What it does is enter the table “sitesynch” on the SQL server and deletes connections to any old Sharepoint config database that you may …