We've never had SSP restores work. MS advised us that recreation of the SSP from configuration documenation is the supported methodology.
On Thu, Jan 22, 2009 at 1:56 PM, Simon Ashworth <[email protected]>wrote: > Hey Guys, > > > > I'm currently performing a migration of an SQL server including all MOSS > 2007 config and content databases. I've used a technet article > http://technet.microsoft.com/en-us/library/cc512725.aspx that states a > process to use for the migration but have fallen foul at the final stage – > restoring the original SSP. The high level process I have followed (as per > the article) is: > > > > · Perform an SSP backup via Central Admin > > · Used STSADM to remove SSP from the farm > > · Stopped farm services > > · Performed SQL backups of all content and configuration dbs > > · Restored database (via SQL) to new server > > · Recreated SQL users & permissions > > · Used STSADM renameserver command specifying new SQL server > > · Restarted Central admin server > > · Restore SSP via Central Admin > > > > I can access the Central Admin site and also browse to the web apps and can > confirm that these are running off the new SQL server, all good here, but > the final step (the SSP restore) appears to hang stating that the SSP is 30 > percent complete but goes no further. I left the job running overnight but > I believe the timer service cancelled it after running for 9 hours. I've > since attempt the restore numerous times with different accounts (just in > case the issue was permissions based) still with no luck. I've checked the > SharePoint logs, event logs and SQL logs but can't see anything pointing > towards a resolution. Can anyone offer some advice? > > > > For information the SQL servers in question are at the same version/SP > level (SQL 2005 SP2). > > > > Simon Ashworth > > > ------------------------------ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozmoss > Other lists you might want to join: http://www.codify.com/lists > -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists
