MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Prescan and spsadm repairorphans

  Asked By: Emanuel    Date: Mar 11    Category: MOSS    Views: 1058

I ran prescan and it says i have 12 sites, that i believe to be

I have tried using stsadm to find list of orphan sites, and it found 0
items: command i tried:
stsadm -o databaserepair -url http://localhost/sites -databasename

I am now trying to use spsadm.exe repairorphans command and MS says I
need Post SP2 hotfix for this (kb 918741). Has anyone tried this and
had any luck? Could anyone send me the hotfix? any help is



9 Answers Found

Answer #1    Answered By: Caleb Gordon     Answered On: Mar 11

Give Microsoft a call to get the hotfix, it's free, just takes a little time
talking to them on the phone.

As for it's usefulness, works like a champ. Cleaned up my database using it
saving tons of time (WSS Split depending on how big the db is and how many
sites you've got can be quite the painful process).

Answer #2    Answered By: Himanshu Gohil     Answered On: Mar 11

Personally, the hot fix didn't help at all for me. What did help, though, was
to run a SPS backup operation. Supposedly is has a method to deal with orphaned objects.

Answer #3    Answered By: Ashton Schroeder     Answered On: Mar 11

I will try the hotfix  first.
Does anybody know how to migrate from SPS 03 to MOSS, and only pull certain
content like \sites\ and my sites, but not areas or portal content?

Answer #4    Answered By: Iris Ballard     Answered On: Mar 11

To do that, really all you need to do is take the content databases and
attach them to a WSS instance, then do backups of everything under /sites
and /personal. Restore that to a fresh set of content databases and then
take that content and migrate it to a MOSS system after you've run prescan.

Answer #5    Answered By: Jamila Guthrie     Answered On: Mar 11

I don't think you can pull site collections within managed paths without
first migrating the root site collection of a web application.

Answer #6    Answered By: Kalpana Ghatge     Answered On: Mar 11

You are correct good sir. That's where my trickery comes into play where
you are taking the portal's content DBs and attaching it to a WSS instance
(v2) and backing up anything that is /personal or /sites. Drop your content
DBs, restore all of your /sites and /personal into a fresh content db, run
pre-scan, pop those content DBs over to your MOSS server and wallah, you're

Answer #7    Answered By: Bobbie Rodgers     Answered On: Mar 11

Following your instructions from your previous post, how did you back up
only /personal and /sites? Did you have to do each individually using cmd
such as:

stsadm -o backup -url  "http://myserver/sites/test1" -filename "C:\WSS\Site

I don't see any way to say back up everything under /sites/* into one .dat

Is there an sps tool to do this i don't know about?

p.s. on the phone 3 hrs w/ MS to get wrong hotfix  sent to me. They said kb
924294 replaced 918741, which is wrong. 924294 doesn't fix repair orphans..
i called again and they said hotfix .exe for 918741 is deleted, apparently
they need Google search over there to find  it...just a heads up in case
anyone is also trying to get the repairorphans. hotfix...

Answer #8    Answered By: Vinay Thakur     Answered On: Mar 11

My apologies for not getting back to you sooner.

Nonetheless, you can use the spbackup utility to batch script them.
Typically what I'll do is run an enumeration of all sites, use a little bit
of regular expressions to clean things up and then write a quick and dirty
batch script to do my bidding for me.

The spbackup tool is a part of the resource kit from Microsoft for WSS v2.
It will backup any site collection (i.e. /sites/ or /personal/).

Sorry to hear that you had to waste that much time with MS tech support,
that stinks.

Answer #9    Answered By: Davon Henson     Answered On: Mar 11

The hot fix should work for you. If you could not find  any orphan
objects to remove and receive error reports from Prescan, let me know
since I had the same issues and had to remove them from DB directly.

Didn't find what you were looking for? Find more on Prescan and spsadm repairorphans Or get search suggestion and latest updates.