Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to determine if a site collection is in a content db backup file

  Asked By: Cherish    Date: Jan 24    Category: Sharepoint    Views: 1822

A user deleted his site accidentally. We have many content databases
for one web application--is there an stsadm command or some other
method for "readin" a db backup file to see which site collections it



4 Answers Found

Answer #1    Answered By: Laquita Mcgowan     Answered On: Jan 24

If you can restore a ConfigDB database from before the site  collection
was deleted, you can look in the Site table and see which Content
Database that Site collection  was in. Use the corresponding DatabaseId
and look for it in the Databases table of the ConfigDB. That's the
ContentDB you're looking for.

Answer #2    Answered By: Elijah Davis     Answered On: Jan 24

Are direct SQL queries supported by MS?

Answer #3    Answered By: Akanksha Jain     Answered On: Jan 24

No, a read-only query against a database which is not attached is not a

Answer #4    Answered By: Bhupendra Borkar     Answered On: Jan 24

We did a restore of Config DB and for some reason, the Sites and
Database tables both have 0 rows. We then did another backup  of
Configu_DB, just to doublecheck, and it shows 0 rows as well. (We
used SQL Management Studio to run the query.) Could this be a
permission issue? Can you think of any other explanations?