Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

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

Asked By: Cherish Langley Date: Jan 24, 2010 Category: Sharepoint Views: 415

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
contains?

Tagged:how to determine if site collection is in content db backup file

4 Answers Found

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

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, 2010

Are direct SQL queries supported by MS?

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

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

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

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?

Didn't find what you were looking for? Find more on How to determine if a site collection is in a content db backup file Or get search suggestion and latest updates.