SHPNT
asked on
Orphanded Site
Expert,
Please help. We have MOSS with SP2. My problem is that I have an orphanded site collection in s content database. The contnet DB name is CDB1.
I ran a stsadm commend that is below.
stsadm -o databaserepair -url http://servername:12071 -databasename CDB1 -deletecorruption
Even after the commend above, the orphan site does not get fixed, and the orphanded item does not get deleted. For example, each orphanded item, I havce "deleted" = NO".
Please help. We have MOSS with SP2. My problem is that I have an orphanded site collection in s content database. The contnet DB name is CDB1.
I ran a stsadm commend that is below.
stsadm -o databaserepair -url http://servername:12071 -databasename CDB1 -deletecorruption
Even after the commend above, the orphan site does not get fixed, and the orphanded item does not get deleted. For example, each orphanded item, I havce "deleted" = NO".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i'm guessing one could search Google on how to do it within SQL, but no one on this site would tell you how or recommend doing it as its not supported by microsoft.
Do you want to restore the site collection?
Have you downloaded the Sharepoint Administration Toolkit from Microsoft? It has a tool to manage site collections in the content databases including a delete.
Have you downloaded the Sharepoint Administration Toolkit from Microsoft? It has a tool to manage site collections in the content databases including a delete.
ASKER
No, I just wanted to fix the content DB. I guess I don't have anyother choice but to replace the CDB.
My answer was correct. You did NOT have to replace the content DB.
ASKER
Tedbilly,
Could you be more detail?
Do you mean I can fix orphanded site that is NOT fixed by stsadm -o databaserepair with using the Sharepoint Administration Toolkit from Microsoft?
Thanks,
Could you be more detail?
Do you mean I can fix orphanded site that is NOT fixed by stsadm -o databaserepair with using the Sharepoint Administration Toolkit from Microsoft?
Thanks,
Yes it can fix it. A content database is full of one or more site collections. The toolkit allows you to see all the site collections in the content database and remove them or move them.
It's no risk to install. Simply download it and install it. It becomes an option in Sharepoint Central Admin to use on your installation.
It's no risk to install. Simply download it and install it. It becomes an option in Sharepoint Central Admin to use on your installation.
ASKER
Hi tedbility,
Sorry about not getting back to you sooner.
I just installed it onto my VM ( I want to test it first).
Could you guide me to find where and how I can delete orphanded sites using this tool?
Thanks,
Sorry about not getting back to you sooner.
I just installed it onto my VM ( I want to test it first).
Could you guide me to find where and how I can delete orphanded sites using this tool?
Thanks,
Sure:
1) Open Central Admin
2) Select Application Management
3) Select 'Batch Site Manager'
4) In the top paragraph select the 'Click Here' link to refresh the data
5) When refresh complete use the 'Web Application' drop down to select the web application that owns the content database with the orphaned site collection
6) Select the URL for the orphaned site collection
7) Select the 'Delete' command and follow the instructions
1) Open Central Admin
2) Select Application Management
3) Select 'Batch Site Manager'
4) In the top paragraph select the 'Click Here' link to refresh the data
5) When refresh complete use the 'Web Application' drop down to select the web application that owns the content database with the orphaned site collection
6) Select the URL for the orphaned site collection
7) Select the 'Delete' command and follow the instructions
ASKER
Hi Tedbiltiy,
While I was waiting for your answer, I re-ran the stsadm -o databaserepair -url http://servername:12071 -databasename CDB1 -deletecorruption, and this time it magically worked.
It is very strange. I don't know what has been changed during last few weeks.
Anyway my problem is gone now. Thanks,
While I was waiting for your answer, I re-ran the stsadm -o databaserepair -url http://servername:12071 -databasename CDB1 -deletecorruption, and this time it magically worked.
It is very strange. I don't know what has been changed during last few weeks.
Anyway my problem is gone now. Thanks,
Well the tool you installed is quite useful anyway so no loss in time. Cheers
ASKER
Thanks,