locked
Site Collection Database Recovery - MOSS 2007 RRS feed

  • Question

  • Hi All,

    Suddenly One of my Site Collection disappeared from the Site Collection list, even in the Central Admin its not there.

    When I checked the MSSQL Data folder location, the .mdf file is still there. even size is around 10+gb I felt still the data exist in the database.

    So I created new site collection and attached the Database, but the new site collection is not showing any data..

    May I know what is the problem? does anyone faced similar problems in MOSS 2007 Environment?

    Is there is any possible way to recover the data?


    Thanks Vivek SharePoint Foundation 2010 Book
    http://www.redpipit.com

    Wednesday, August 7, 2013 2:54 PM

Answers

  • Hi Vivek,

    Here is another similar post, you can use the sql command to confirm the site collection exist in web application database (site collection count), then attach db again.

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/f94e8751-dedb-4da8-ae70-ec8765df0e07/restore-sharepoint-missing-site-collections

    Thanks,
    Daniel Yang
    Forum Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com. 

    Daniel Yang
    TechNet Community Support

    Thursday, August 8, 2013 8:49 AM
    Moderator
  • If the other solutions haven't worked, you should use a SQL (or stsadm) backup of your site collection (from yesterday, 2 days ago) and try to attach it to a SharePoint test environment.

    If it's acceptable for your users to lose some data, your may use this approach to restore your site collection in your production farm.

    Thursday, August 8, 2013 9:06 AM

All replies

  • Hi Vivek,

    1Go to Central Administration--> Application Management and look at the list of content databases for your web
    application. See if the newly attached content database shows "Number of Site collection" as "0" then follow steps 2 and 3

    2. At the command prompt, use stsadm command to detach the content database from your site collection

    stsadm.exe -o deletecontentdb -url <URL name> -databasename <database name>

    and the Add Content Database command again with assignnewdatabaseid flag

    stsadm.exe -o addcontentdb  -url <URL name> -assignnewdatabaseid  -databasename <database name>

    If the "Number of Site collection" is "1", content database is available and some urls on your site not working.

    Try to browse the urls /_layouts/settings.aspx">http://<yoursitecollection>/_layouts/settings.aspx to see if the content is intact.

    Wednesday, August 7, 2013 9:57 PM
  • Tried these, still not working...

    Thanks Vivek SharePoint Foundation 2010 Book
    http://www.redpipit.com

    Thursday, August 8, 2013 4:35 AM
  • Hi Vivek,

    Here is another similar post, you can use the sql command to confirm the site collection exist in web application database (site collection count), then attach db again.

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/f94e8751-dedb-4da8-ae70-ec8765df0e07/restore-sharepoint-missing-site-collections

    Thanks,
    Daniel Yang
    Forum Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com. 

    Daniel Yang
    TechNet Community Support

    Thursday, August 8, 2013 8:49 AM
    Moderator
  • If the other solutions haven't worked, you should use a SQL (or stsadm) backup of your site collection (from yesterday, 2 days ago) and try to attach it to a SharePoint test environment.

    If it's acceptable for your users to lose some data, your may use this approach to restore your site collection in your production farm.

    Thursday, August 8, 2013 9:06 AM