Solved

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

Posted on 2015-01-09
2
154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

738 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