Solved

Restore SBS 2003 CompanyWeb calendar Only from the flat files?

Posted on 2012-03-31
4
481 Views
Last Modified: 2012-04-11
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. :-)
0
Comment
Question by:brandonsharpe
  • 2
  • 2
4 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37793039
If you ever need remote assistance with your SharePoint environment, I'm available.  My email is in my profile.

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.
0
 

Author Comment

by:brandonsharpe
ID: 37793847
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.
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 37794024
When you try to replace the mdf and ldf, it doesn't work.......does it give you an error?

You could build a new farm on the new server.  Attach the content db mdf and ldf to the SQL instance.  Create a web app in the new farm and attach the content db to it.  You will prob have to adjust SQL permissions on the db(grant permission to the farm account)
0
 

Author Comment

by:brandonsharpe
ID: 37833488
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.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Port SharePoint 365 Add-In Developed in Visual Studio to Site 2 26
IPV6 Issues 3 35
Help  needed 3 34
Email Notifications for SQL 2005 9 35
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question