HOW-TO:11:: WSS Current Number of Sites 0 after SQL Restore of Content DB

Posted on February 7, 2008 by spsharat

You restore a content db via SQL restore and attach it to another SharePoint web application via Central Administration “Add a content database” and for some reasone the “Current Number of Sites” is 0.

How to fix it:

1. Remove the content databases from the virtual server using SP Central administration.

2. Delete the row from [restore_db].sites table.

3. Re add the content database back to Virtual server using SP Central administration page.

You should see the sites.

Like this:

Be the first to like this post.

Filed under: HowTo

One Response

Ali, on March 27, 2008 at 7:50 am said:

Hi,

I have the same exact problem, can you provide a step by step explanation of each of the above 3 steps ?

I do not know how start and what do you mean by removing the database from virtual server !!

Please help