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: 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
