MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Moss 2007 Issue

  Asked By: Hunter    Date: Apr 25    Category: MOSS    Views: 1244

I have a major issue with Moss 2007, first let me preface this by
saying that I did a gradual upgrade from SharePoint 2003. All was well
for 6 months until 3 weeks ago when I noticed that there were some site
collections showing up during enumsites with "File Exists" message. So
I did a little bit of research and found that larger sites that are
deleted through the admin pages sometimes do this so I figured I would
just detach the content db and reattach the content db. Ever since I
have done that I have been unable to browse to the root level site
collection, I get a 404 page not found error. When I look in the
sitemap table in the config db there is no entry for my root level
site, however all site data is still in the content database. If I take
an old version of the the database where I can browse to the root level
site collection, then restore the content database to that database
without having to detach and reattach the content db I can browse to
the site in my development enviroment.

Has anyone seen anything like this before? I have been trying to get
this issue resolved for 3 weeks and also have a case open with
Microsoft who have literally been no help.



1 Answer Found

Answer #1    Answered By: Mike Lamb     Answered On: Apr 25

You could try merging the contentdb's by conducting the following:

When I first heard about it, I had to test the simplicity to do this
with the new stsadm option that was inserted in the latest security
hotfix for WSS of October 9th. This command is not very well documented
anywhere. I heard about it by Todd Klindt in one of his TechEd sessions
last week and tested it today. I must say it works like a charm.

This is the command:

stsadm.exe -o mergecontentdbs
-url <url>
-sourcedatabasename <source database name>
-destinationdatabasename <destination datbabase name>
[-operation <1-3>
1 - Analyze (default)
2 - Full Database Merge
3 - Read from file]
[-filename <file generated from stsadm -o enumsites>]

See also:
stsadm -o enumcontentdbs -url <url>
stsadm -o enumsites -url <url> -databasename <database>

The way this is to be used as suggested by Todd is, to use a file with
the site collections you want to move. As you can see above this file
can be generated by the stsadm -o enumsites command. All you need to do
then, is open up the file and remove the lines with the site collections
you do not want to move. Save the rest and feed it to the new command.

e.g. C:\stsadm -o mergecontentdbs -url http://wss <http://wss/>
-sourcedatabasename WSS_Content_7fc30dd3c1514cdda6b68bd8d10a0463
-destinationdatabasename WSS_Content -operation 3 -filename sites.txt

So, I hope you enjoy this cool new command and use it !

Didn't find what you were looking for? Find more on Moss 2007 Issue Or get search suggestion and latest updates.