Solved

Single Server SQL sharepoint 2010 accessing prior content and admin DB from defunct single server farm

Posted on 2015-01-09
2
140 Views
Last Modified: 2015-01-10
History -:

Functional Sharepoint 2010 installation became inaccessible after attempts to migrate SQL to a higher capacity version.  This failed due to pre requisite issues and incompatibilities.

Sharepoint became inaccesible, and indeed so did SQL express management studio.

I decided to copy out the sharepoint related SQL MDF and LDF files from the SQL DATA folder.  Remove SQL and sharepoint entirely, and reinstall back as vanilla SQL express, with a view to EITHER starting from scratch and building the site again, and copying content and hopefully config data from the original MDFs,  
OR
After Reinstalling SQL2008Express and Sharepoint 2010 and within Sharepoint Central Admin open the original Content database and previously used sites.


I can almost see some of your heads shaking now.   !  The outcome, has naturally been a frustrating trail of Microsoft error messages and google searches that lead to yet more error messages.


Current state of Play.

I have access to Central Administration of the Vanilla new installation of Sharepoint and SQLExpress.
Within SQL management studio, I can see the"new" empty Sharepoint Databases.
Within SQL Express, i have ATTACHED the previous Admin and Content databases which i intended to simply point Sharepoint Central Admin to, and hey presto.  Not!.


At this stage being the Sharepoint installation is basically clean,  i ask what next.  I have tried numerous things to mount the old Databases, but all resulted in failure mostly to do with Privaledges,  so rather than pick through the error messages that maybe due to my incorrect approach to this issue, i ask whether there is be a defacto way of getting back to some resemblance of functionality and data availability.

Alternatively, i would hope to be able to establish some method to browse the old MDF's and extract docs and so on.

We do have backups of course, but part of this excercise is to wash out some of the remaining "glitches" caused by failed attempts to update to SQL 2012, and newer releases of Sharepoint.
0
Comment
Question by:davesheppard
  • 2
2 Comments
 

Accepted Solution

by:
davesheppard earned 0 total points
ID: 40541920
Self answered.

I was able to resolve the issue, by Attaching the old SharePoint Content database to SQL, then using the restore from unattached database option in Central Admin Backup and Restore.

This allowed to Export the Site within the Original SQL content DB.

After Exporting, I then used the import-spsite powershell command and restored it the to a site by the name of the original, so users can use the original URL they always used to.

The only downside to the process, was that every file is now dated todays date.  All Versions were included with the export which was a selectable option in the export process.

I would say documentation is quite weak in this area and there isn't a lot of "overview" description of the various authentication and connections between SP, SQL and IIS. making the Faulted scenario quite daunting.

Suffice to say that as long as you havea copy of the MDF/LDF file combo, you CAN get the data out, and back in!.

The end result is we have the site back up with the original url, and the original content, just file dates are changed.

W00p.
0
 

Author Closing Comment

by:davesheppard
ID: 40541921
Self answered.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now