brandonsharpe
asked on
Restore SBS 2003 CompanyWeb calendar Only from the flat files?
Ok so I have a job of recovering a calendar that was used for an event schedule. The situation is that there was never a backup done except for using Carbonite on the C drive. I have re-installed the server with the same server name and domain. I tried stopping the mssqlsharepoint service and over-righting the two DB files (STS_1.mdf and STS_1_log.LDF) and each one individually each time stopping and restarting the service. Now I knew before I started that this had a slim chance of working but I had to try because everything else i could find involved backing up before restoring and this just wasn't done.
Please someone help it is driving me mad I tell you MADDDDDD.
ps i am not the genius that set this up just the fool tasked to clean up the mess. :-)
Please someone help it is driving me mad I tell you MADDDDDD.
ps i am not the genius that set this up just the fool tasked to clean up the mess. :-)
ASKER
With just the flat files how would i do that? If I try and replace the data file or even the whole SharePoint MSSQL file it doesn't work. I am using another server to recover the calender data so restoring it all is not a problem it is just that I don't know how to restore the entire thing by just copying the files to the right locations.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, in my situation I just needed the data from the old database what I found out is that I could just use the Microsoft SQL Server 2008 Management Studio Express to mount and export the data to a flat SQL file and restored the data from there. ACH1LLES gave me the final missing link when he mentioned the permissions.
Ok, so basically you have backups of each of your database files. Unfortunately you won't be able to pull the calendar, or any site, directly from these types of backup. You are going to have to restore ALL your SharePoint databases and overwrite the entire farm.
OR, if you have a second server laying around, you can try to install the same version of SharePoint and SQL on it, restore all your files there, and see if it comes up. At that point, it would be possible to export the individual calendar.