none
Restore a deleted SharePoint Site Collection in MOSS 2007 (Content Db for this site Collection exists and no backups are available) RRS feed

  • Question

  •  

    Hi,

    We deleted a site collection (MOSS 2007) from Site Settings and not via Central Admin.

    This site collection contain only one site under it.

    After checking the Central Admin à Application Management à Manage ContentDatabase we found the Content DB available for this site collection.We have verified the DB server and we do see the Content DB exists here.

    Now we want to restore this Site Collection back to its original state and as of now we are not sure if the DB backups are available or not.

    Please let know the restoration procedure for the same

    Thanks & Regards,

    Sudheer


    Thanks & Regards, Sudheer

    Thursday, March 8, 2012 11:18 AM

Answers

  • Hi Sudheer,

    You actually can't delete a site collection from the UI (user interface) - what you may have done is deleted the root level site for that site collection. This is why you are still seeing the content database associated with that site collection. Can you access any other subsite from that site collection with paths like this? http://YoursitecollectionURL/site1? or http://YourSitecollectionURL/_layouts/viewlsts.aspx?

    Now you have two options - if you have SharePoint backup (stsadm/ central admin) you can restore that site collection/ site. Other option is - find out if you have a backup of the SQL database from the SQL side (from the time before you actually deleted the site). Once you restore the database you will get your site back. Mind you you will loose any changes after the database was backed up.

    Hope this helps!


    BlueSky2010
    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Thursday, March 8, 2012 2:27 PM

All replies

  • Hi Sudheer,

    You actually can't delete a site collection from the UI (user interface) - what you may have done is deleted the root level site for that site collection. This is why you are still seeing the content database associated with that site collection. Can you access any other subsite from that site collection with paths like this? http://YoursitecollectionURL/site1? or http://YourSitecollectionURL/_layouts/viewlsts.aspx?

    Now you have two options - if you have SharePoint backup (stsadm/ central admin) you can restore that site collection/ site. Other option is - find out if you have a backup of the SQL database from the SQL side (from the time before you actually deleted the site). Once you restore the database you will get your site back. Mind you you will loose any changes after the database was backed up.

    Hope this helps!


    BlueSky2010
    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Thursday, March 8, 2012 2:27 PM
  • Hi,

    Same case I have done. I have deleted the site collection but I don't have site backup and sql backup also. but I can see my content db in SSMS. please suggest me the right path how to restore site data back.

    Wednesday, June 19, 2013 12:25 PM
  • Hi There - We have the exact same issue.  We have a backup of the db from SqL that we want to restore in our DMZ.  Do you need to run the config wizard after you do the restore of the database, or just restoring it would be suffice. This is in our DMZ servers and we are load balanced.  We had a site collection that we had to delete to do a fresh content deployment everything from staging to DMZ again. There was a site under this site collection that somehow was removed as well. Any more information would be appreciated. Thanks.

    Thursday, September 5, 2013 2:08 PM