I searched this forum but didn't find a satisfactory answer (though I did see others with similar questions). I have a production MOSS environment (1 wfe, 1sql) up and running andI want to move it across the country to another location. I need to restore the production environment onto a duplicate environment, so we can box and ship the original. The backup of the production seems to run fine, but when restoring, it always fails on restoring the SharedServices1 item(s). It fails with the error: "Error: Object Sharepoint - SSP failed in event OnRestore.Argument Exception:The IIS Web Site you have selected is in use by SharePoint. You must select another port or hostname." I receive this error when I try only the SharedServices1 item restore or Farm level restore from stsadm or from the Central Admin GUI. I've uninstalled/reinstalled MOSS, removed re-added IIS, all to no avail. Thanks!!

you can try stsadm -o restore -overwrite but be carefull, you might break the sites on the server your restoring to

Yeah, I've tried the overwrite option from the command line. Unfortunately, I still get the same error. Thanks for the response though.

Hi JP, This can happen if you delete web sites in inetmgr, rather than through the GUI. It doesn't cleanly remove IIS associations from the config database, so although you cannot see any web sites on inetmgr on your desired port/URL, they are still "in use" by SharePoint. The solution for me was to use the "Remove SharePoint from IIS Web Site" option on the Operations tab of Central Admin - this may work for you. Good luck, Poolio

Thanks for the reply, Poolio. I tried your suggestion without any luck. I went as far as to go ahead and delete all the databases and rerun the config wizard again... then restore. It's still bombing when it gets to the Shared Services Provider. Below is the log for the restore: (I trimmed it down so it would fit in the post) [10/3/2007 7:30:20 AM]: Verbose: The backup/restore process included the following objects:[10/3/2007 7:30:20 AM]: Farm\ [SharePoint_Config]\ Windows SharePoint Services Web Application\ SharePoint - MySites\ WSS_Content_MySites\ SharePoint - Portal\ WSS_Content_Portal\ [WSS_Administration]\ [Web Application]\ [SharePoint_AdminContent_361f63a4-7d2c-4fe1-a27f-ddf8aa8b8930]\ SharedServices1\ [SharePoint - SSP]\ WSS_Content\ [SharedServices1_DB]\ [UserProfileApplication]\ [SessionStateSharedApplication]\ [Shared Search Index]\ [SharedServices1_Search_DB]\ Global Search Settings\ Windows SharePoint Services Search\ [Search instance]\ [WSS_Search_CPI-MOSS-WFE1]\ [10/3/2007 7:31:21 AM]: Progress: Starting Restore.[10/3/2007 7:31:21 AM]: Start Time: 10/3/2007 7:31:21 AM.[10/3/2007 7:31:21 AM]: Verbose: Requested by CPI\service-moss-admin.[10/3/2007 7:31:21 AM]: Verbose: Backup/Restore Settings:RestoreBackup Method: FullTop Component: FarmDirectory: \\cpi-mosssql2-ch\moss_restoreProgress updated: 5[10/3/2007 7:31:21 AM]: Restore Method: NewBackup ID: f77456b8-5224-4944-b5bf-d5b4b38c6259 [10/3/2007 7:31:21 AM]: Verbose: Starting OnRestore event.[10/3/2007 7:31:22 AM]: Verbose: Starting object: Farm.[10/3/2007 7:31:22 AM]: Verbose: [Farm] The configuration database and central administration content database components cannot be restored.[10/3/2007 7:31:22 AM]: Progress: [Farm] 50 percent complete.[10/3/2007 7:31:22 AM]: Verbose: Starting object: Windows SharePoint Services Web Application.[10/3/2007 7:31:22 AM]: Progress: [Windows SharePoint Services Web Application] 50 percent complete.[10/3/2007 7:31:23 AM]: Verbose: Starting object: SharePoint - MySites.[10/3/2007 7:31:23 AM]: Verbose: [SharePoint - MySites] Trying to connect to Web application http://mysite2:13934/.[10/3/2007 7:31:23 AM]: Verbose: [SharePoint - MySites] Creating a new Web application.[10/3/2007 7:31:42 AM]: Verbose: [SharePoint - MySites] Provisioning a new Web application.[10/3/2007 7:34:01 AM]: Verbose: [SharePoint - MySites] WebApp (6877b67b-d3f4-443c-bacc-a7409877df0a): Adding propertiy [Microsoft.Office.Server.SharedResourceProvider], value = [][10/3/2007 7:34:01 AM]: Verbose: [SharePoint - MySites] WebApp (6877b67b-d3f4-443c-bacc-a7409877df0a): Adding propertiy [Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False][10/3/2007 7:34:09 AM]: Progress: [SharePoint - MySites] 50 percent complete.[10/3/2007 7:34:10 AM]: Verbose: Starting object: WSS_Content_MySites.[10/3/2007 7:34:10 AM]: Verbose: [WSS_Content_MySites] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=WSS_Content_MySites;Integrated Security=True.[10/3/2007 7:34:10 AM]: Verbose: [WSS_Content_MySites] SQL command started at: 10/3/2007 7:34:10 AM. This command may take a while to complete and without notification.[10/3/2007 7:34:10 AM]: Verbose: [WSS_Content_MySites] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [WSS_Content_MySites] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\00000015.bak, @db_OldName=WSS_Content_MySites, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_MySites.mdf, @db_OldLogName=WSS_Content_MySites_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_MySites_log.ldf, @db_name=WSS_Content_MySites[10/3/2007 7:34:17 AM]: Progress: [WSS_Content_MySites] 100 percent complete.[10/3/2007 7:34:17 AM]: Verbose: [WSS_Content_MySites] SQL Server Message: Processed 3472 pages for database 'WSS_Content_MySites', file 'WSS_Content_MySites' on file 1.[10/3/2007 7:34:17 AM]: Verbose: [WSS_Content_MySites] SQL Server Message: Processed 1 pages for database 'WSS_Content_MySites', file 'WSS_Content_MySites_log' on file 1.[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] SQL Server Message: RESTORE DATABASE successfully processed 3473 pages in 1.270 seconds (22.402 MB/sec).[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] SQL command completed at: 10/3/2007 7:34:21 AM.[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] Verifying that the database restoration is complete.[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=WSS_Content_MySites[10/3/2007 7:34:21 AM]: Debug: [WSS_Content_MySites] Database status is 65536.[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] SQL Server Command: SELECT TOP 1 1 FROM [WSS_Content_MySites]..sysobjects[10/3/2007 7:34:21 AM]: Verbose: [WSS_Content_MySites] Database restoration has been verified.[10/3/2007 7:34:21 AM]: Verbose: Starting object: SharePoint - Portal.[10/3/2007 7:34:21 AM]: Verbose: [SharePoint - Portal] Trying to connect to Web application http://portal2/.[10/3/2007 7:34:22 AM]: Verbose: [SharePoint - Portal] Creating a new Web application.[10/3/2007 7:34:28 AM]: Verbose: [SharePoint - Portal] Provisioning a new Web application.[10/3/2007 7:36:34 AM]: Progress: [SharePoint - Portal] 50 percent complete.[10/3/2007 7:36:34 AM]: Verbose: Starting object: WSS_Content_Portal.[10/3/2007 7:36:34 AM]: Verbose: [WSS_Content_Portal] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=WSS_Content_Portal;Integrated Security=True.[10/3/2007 7:36:34 AM]: Verbose: [WSS_Content_Portal] SQL command started at: 10/3/2007 7:36:34 AM. This command may take a while to complete and without notification.[10/3/2007 7:36:34 AM]: Verbose: [WSS_Content_Portal] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [WSS_Content_Portal] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\00000017.bak, @db_OldName=WSS_Content_Portal, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_Portal.mdf, @db_OldLogName=WSS_Content_Portal_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_Portal_log.ldf, @db_name=WSS_Content_Portal[10/3/2007 7:38:53 AM]: Progress: [WSS_Content_Portal] 100 percent complete.[10/3/2007 7:38:53 AM]: Verbose: [WSS_Content_Portal] SQL Server Message: Processed 63056 pages for database 'WSS_Content_Portal', file 'WSS_Content_Portal' on file 1.[10/3/2007 7:38:53 AM]: Verbose: [WSS_Content_Portal] SQL Server Message: Processed 1 pages for database 'WSS_Content_Portal', file 'WSS_Content_Portal_log' on file 1.[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] SQL Server Message: RESTORE DATABASE successfully processed 63057 pages in 106.014 seconds (4.872 MB/sec).[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] SQL command completed at: 10/3/2007 7:39:00 AM.[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] Verifying that the database restoration is complete.[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=WSS_Content_Portal[10/3/2007 7:39:00 AM]: Debug: [WSS_Content_Portal] Database status is 65536.[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] SQL Server Command: SELECT TOP 1 1 FROM [WSS_Content_Portal]..sysobjects[10/3/2007 7:39:00 AM]: Verbose: [WSS_Content_Portal] Database restoration has been verified.[10/3/2007 7:39:01 AM]: Verbose: Starting object: WSS_Administration.[10/3/2007 7:39:01 AM]: Progress: [WSS_Administration] 50 percent complete.[10/3/2007 7:39:01 AM]: Verbose: Starting object: SharedServices1.[10/3/2007 7:39:01 AM]: Progress: [SharedServices1] 10 percent complete.[10/3/2007 7:39:01 AM]: Progress: [SharedServices1] 20 percent complete.[10/3/2007 7:39:03 AM]: Progress: [SharedServices1] 30 percent complete.[10/3/2007 7:39:23 AM]: Progress: [SharedServices1] 40 percent complete.[10/3/2007 7:40:39 AM]: Progress: [SharedServices1] 50 percent complete.[10/3/2007 7:40:39 AM]: Verbose: Starting object: SharePoint - SSP.[10/3/2007 7:40:39 AM]: Verbose: [SharePoint - SSP] Trying to connect to Web application http://ssp2/.[10/3/2007 7:40:39 AM]: Verbose: [SharePoint - SSP] Creating a new Web application.[10/3/2007 7:40:43 AM]: Error: Object SharePoint - SSP failed in event OnRestore. For more information, see the error log located in the backup directory.ArgumentException: The IIS Web Site you have selected is in use by SharePoint. You must select another port or hostname.[10/3/2007 7:40:43 AM]: Debug: at Microsoft.SharePoint.Administration.SPWebApplication.CreateIisSettingsObject(String iisServerComment, Boolean secureSocketsLayer, String iisHostHeader, Int32 iisPort, Boolean iisAllowAnonymous, Boolean iisEnsureNTLM, DirectoryInfo iisRootDirectory, SPFarm farm) at Microsoft.SharePoint.Administration.SPWebApplication.CreateDefaultInstance(SPWebService service, Guid id, String applicationPoolId, IdentityType identityType, String applicationPoolUsername, SecureString applicationPoolPassword, String iisServerComment, Boolean secureSocketsLayer, String iisHostHeader, Int32 iisPort, Boolean iisAllowAnonymous, DirectoryInfo iisRootDirectory, Uri defaultZoneUri, Boolean iisEnsureNTLM, Boolean createDatabase, String databaseServer, String databaseName, String databaseUsername, String databasePassword, SPSearchServiceInstance searchServiceInstance, Boolean isPaired, Boolean autoActivateFeatures) at Microsoft.SharePoint.Administration.SPWebApplication.OnRestore(Object sender, SPRestoreInformation args)[10/3/2007 7:40:44 AM]: Verbose: Starting object: WSS_Content.[10/3/2007 7:40:44 AM]: Verbose: [WSS_Content] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=WSS_Content;Integrated Security=True.[10/3/2007 7:40:44 AM]: Verbose: [WSS_Content] SQL command started at: 10/3/2007 7:40:44 AM. This command may take a while to complete and without notification.[10/3/2007 7:40:44 AM]: Verbose: [WSS_Content] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [WSS_Content] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\0000001B.bak, @db_OldName=WSS_Content, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content.mdf, @db_OldLogName=WSS_Content_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Content_log.ldf, @db_name=WSS_Content[10/3/2007 7:40:49 AM]: Progress: [WSS_Content] 100 percent complete.[10/3/2007 7:40:49 AM]: Verbose: [WSS_Content] SQL Server Message: Processed 1488 pages for database 'WSS_Content', file 'WSS_Content' on file 1.[10/3/2007 7:40:49 AM]: Verbose: [WSS_Content] SQL Server Message: Processed 1 pages for database 'WSS_Content', file 'WSS_Content_log' on file 1.[10/3/2007 7:40:52 AM]: Verbose: [WSS_Content] SQL Server Message: RESTORE DATABASE successfully processed 1489 pages in 0.510 seconds (23.917 MB/sec).[10/3/2007 7:40:52 AM]: Verbose: [WSS_Content] SQL command completed at: 10/3/2007 7:40:52 AM.[10/3/2007 7:40:53 AM]: Verbose: [WSS_Content] Verifying that the database restoration is complete.[10/3/2007 7:40:53 AM]: Verbose: [WSS_Content] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=WSS_Content[10/3/2007 7:40:53 AM]: Debug: [WSS_Content] Database status is 65536.[10/3/2007 7:40:53 AM]: Verbose: [WSS_Content] SQL Server Command: SELECT TOP 1 1 FROM [WSS_Content]..sysobjects[10/3/2007 7:40:53 AM]: Verbose: [WSS_Content] Database restoration has been verified.[10/3/2007 7:40:53 AM]: Verbose: Starting object: SharedServices1_DB.[10/3/2007 7:40:53 AM]: Verbose: [SharedServices1_DB] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=SharedServices1_DB;Integrated Security=True.[10/3/2007 7:40:53 AM]: Verbose: [SharedServices1_DB] SQL command started at: 10/3/2007 7:40:53 AM. This command may take a while to complete and without notification.[10/3/2007 7:40:53 AM]: Verbose: [SharedServices1_DB] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [SharedServices1_DB] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\0000001C.bak, @db_OldName=SharedServices1_DB, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharedServices1_DB.mdf, @db_OldLogName=SharedServices1_DB_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharedServices1_DB_log.ldf, @db_name=SharedServices1_DB[10/3/2007 7:40:59 AM]: Progress: [SharedServices1_DB] 100 percent complete.[10/3/2007 7:40:59 AM]: Verbose: [SharedServices1_DB] SQL Server Message: Processed 1728 pages for database 'SharedServices1_DB', file 'SharedServices1_DB' on file 1.[10/3/2007 7:40:59 AM]: Verbose: [SharedServices1_DB] SQL Server Message: Processed 3 pages for database 'SharedServices1_DB', file 'SharedServices1_DB_log' on file 1.[10/3/2007 7:41:02 AM]: Verbose: [SharedServices1_DB] SQL Server Message: RESTORE DATABASE successfully processed 1731 pages in 0.875 seconds (16.200 MB/sec).[10/3/2007 7:41:02 AM]: Verbose: [SharedServices1_DB] SQL command completed at: 10/3/2007 7:41:02 AM.[10/3/2007 7:41:03 AM]: Verbose: [SharedServices1_DB] Verifying that the database restoration is complete.[10/3/2007 7:41:03 AM]: Verbose: [SharedServices1_DB] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=SharedServices1_DB[10/3/2007 7:41:03 AM]: Debug: [SharedServices1_DB] Database status is 65544.[10/3/2007 7:41:03 AM]: Verbose: [SharedServices1_DB] SQL Server Command: SELECT TOP 1 1 FROM [SharedServices1_DB]..sysobjects[10/3/2007 7:41:03 AM]: Verbose: [SharedServices1_DB] Database restoration has been verified.[10/3/2007 7:41:05 AM]: Verbose: Starting object: UserProfileApplication.[10/3/2007 7:41:05 AM]: Progress: [UserProfileApplication] 50 percent complete.[10/3/2007 7:41:05 AM]: Verbose: Starting object: SessionStateSharedApplication.[10/3/2007 7:41:05 AM]: Verbose: Starting object: Shared Search Index.[10/3/2007 7:41:06 AM]: Progress: [Shared Search Index] 10 percent complete.[10/3/2007 7:41:22 AM]: Verbose: Starting object: SharedServices1_Search_DB.[10/3/2007 7:41:23 AM]: Verbose: Starting object: Global Search Settings.[10/3/2007 7:41:23 AM]: Progress: [Global Search Settings] 50 percent complete.[10/3/2007 7:41:23 AM]: Verbose: Starting object: Windows SharePoint Services Search.[10/3/2007 7:41:24 AM]: Progress: [Windows SharePoint Services Search] 50 percent complete.[10/3/2007 7:41:24 AM]: Verbose: Starting object: Search instance.[10/3/2007 7:41:24 AM]: Progress: [Search instance] 50 percent complete.[10/3/2007 7:41:25 AM]: Verbose: Current object: WSS_Search_CPI-MOSSWFE2-CH (previous name: WSS_Search_CPI-MOSS-WFE1).[10/3/2007 7:41:25 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=WSS_Search_CPI-MOSSWFE2-CH;Integrated Security=True.[10/3/2007 7:41:25 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL command started at: 10/3/2007 7:41:25 AM. This command may take a while to complete and without notification.[10/3/2007 7:41:25 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [WSS_Search_CPI-MOSSWFE2-CH] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\0000001E.bak, @db_OldName=WSS_Search_CPI-MOSS-WFE1, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Search_CPI-MOSSWFE2-CH.mdf, @db_OldLogName=WSS_Search_CPI-MOSS-WFE1_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\WSS_Search_CPI-MOSSWFE2-CH_log.ldf, @db_name=WSS_Search_CPI-MOSSWFE2-CH[10/3/2007 7:41:41 AM]: Progress: [WSS_Search_CPI-MOSS-WFE1] 100 percent complete.[10/3/2007 7:41:41 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL Server Message: Processed 7496 pages for database 'WSS_Search_CPI-MOSSWFE2-CH', file 'WSS_Search_CPI-MOSS-WFE1' on file 1.[10/3/2007 7:41:42 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL Server Message: Processed 6 pages for database 'WSS_Search_CPI-MOSSWFE2-CH', file 'WSS_Search_CPI-MOSS-WFE1_log' on file 1.[10/3/2007 7:41:46 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL Server Message: RESTORE DATABASE successfully processed 7502 pages in 8.634 seconds (7.117 MB/sec).[10/3/2007 7:41:46 AM]: Verbose: [WSS_Search_CPI-MOSS-WFE1] SQL command completed at: 10/3/2007 7:41:46 AM.[10/3/2007 7:41:46 AM]: Verbose: [WSS_Search_CPI-MOSSWFE2-CH] Verifying that the database restoration is complete.[10/3/2007 7:41:47 AM]: Verbose: [WSS_Search_CPI-MOSSWFE2-CH] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=WSS_Search_CPI-MOSSWFE2-CH[10/3/2007 7:41:47 AM]: Debug: [WSS_Search_CPI-MOSSWFE2-CH] Database status is 65544.[10/3/2007 7:41:47 AM]: Verbose: [WSS_Search_CPI-MOSSWFE2-CH] SQL Server Command: SELECT TOP 1 1 FROM [WSS_Search_CPI-MOSSWFE2-CH]..sysobjects[10/3/2007 7:41:47 AM]: Verbose: [WSS_Search_CPI-MOSSWFE2-CH] Database restoration has been verified.[10/3/2007 7:41:47 AM]: Verbose: Starting OnPostRestore event.[10/3/2007 7:41:48 AM]: Verbose: Starting object: Farm.[10/3/2007 7:41:48 AM]: Progress: [Farm] 100 percent complete.[10/3/2007 7:41:50 AM]: Verbose: Starting object: Windows SharePoint Services Web Application.[10/3/2007 7:41:50 AM]: Progress: [Windows SharePoint Services Web Application] 100 percent complete.[10/3/2007 7:41:51 AM]: Verbose: Starting object: SharePoint - MySites.[10/3/2007 7:41:51 AM]: Progress: [SharePoint - MySites] 100 percent complete.[10/3/2007 7:41:57 AM]: Verbose: Starting object: WSS_Content_MySites.[10/3/2007 7:41:57 AM]: Verbose: [WSS_Content_MySites] Trying to attach to web application url: http://mysite2:13934/[10/3/2007 7:41:57 AM]: Verbose: [WSS_Content_MySites] Attaching database[10/3/2007 7:42:12 AM]: Verbose: Starting object: SharePoint - Portal.[10/3/2007 7:42:12 AM]: Progress: [SharePoint - Portal] 100 percent complete.[10/3/2007 7:42:13 AM]: Verbose: Starting object: WSS_Content_Portal.[10/3/2007 7:42:13 AM]: Verbose: [WSS_Content_Portal] Trying to attach to web application url: http://portal2/[10/3/2007 7:42:13 AM]: Verbose: [WSS_Content_Portal] Attaching database[10/3/2007 7:42:19 AM]: Verbose: Starting object: WSS_Administration.[10/3/2007 7:42:19 AM]: Progress: [WSS_Administration] 100 percent complete.[10/3/2007 7:42:20 AM]: Verbose: Starting object: SharedServices1.[10/3/2007 7:42:20 AM]: Progress: [SharedServices1] 100 percent complete.[10/3/2007 7:42:24 AM]: Verbose: Starting object: WSS_Content.[10/3/2007 7:42:25 AM]: Error: Object WSS_Content failed in event OnPostRestore. For more information, see the error log located in the backup directory.SPException: Cannot attach database to Web application. Use the command line tool or Central Administration pages to attach the database manually to the proper Web Application.[10/3/2007 7:42:25 AM]: Debug: at Microsoft.SharePoint.Administration.SPContentDatabase.OnPostRestore(Object sender, SPRestoreInformation args)[10/3/2007 7:42:25 AM]: Verbose: Starting object: SharedServices1_DB.[10/3/2007 7:42:26 AM]: Verbose: Starting object: UserProfileApplication.[10/3/2007 7:42:27 AM]: Progress: [UserProfileApplication] 100 percent complete.[10/3/2007 7:42:27 AM]: Verbose: Starting object: SessionStateSharedApplication.[10/3/2007 7:42:36 AM]: Verbose: Starting object: Shared Search Index.[10/3/2007 7:42:36 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Connection String: Data Source=cpi-mosssql2-ch;Initial Catalog=SharedServices1_Search_DB;Integrated Security=True.[10/3/2007 7:42:36 AM]: Verbose: [SharedServices1_Search_DB] SQL command started at: 10/3/2007 7:42:36 AM. This command may take a while to complete and without notification.[10/3/2007 7:42:36 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Command: IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )BEGIN SELECT 1 as ErrorCodeENDELSEBEGIN RESTORE DATABASE [SharedServices1_Search_DB] FROM DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RECOVERYEND @db_location=\\cpi-mosssql2-ch\moss_restore\spbr0000\0000001D.bak, @db_OldName=SharedServices1_Search_DB, @db_NewFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharedServices1_Search_DB.mdf, @db_OldLogName=SharedServices1_Search_DB_log, @db_NewLogFile=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharedServices1_Search_DB_log.ldf, @db_name=SharedServices1_Search_DB[10/3/2007 7:43:02 AM]: Progress: [SharedServices1_Search_DB] 100 percent complete.[10/3/2007 7:43:03 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Message: Processed 10240 pages for database 'SharedServices1_Search_DB', file 'SharedServices1_Search_DB' on file 1.[10/3/2007 7:43:03 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Message: Processed 1 pages for database 'SharedServices1_Search_DB', file 'SharedServices1_Search_DB_log' on file 1.[10/3/2007 7:43:07 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Message: RESTORE DATABASE successfully processed 10241 pages in 16.860 seconds (4.975 MB/sec).[10/3/2007 7:43:07 AM]: Verbose: [SharedServices1_Search_DB] SQL command completed at: 10/3/2007 7:43:07 AM.[10/3/2007 7:43:07 AM]: Verbose: [SharedServices1_Search_DB] Verifying that the database restoration is complete.[10/3/2007 7:43:07 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Command: USE [master] SELECT status FROM master..sysdatabases WHERE name=@db_name@db_name=SharedServices1_Search_DB[10/3/2007 7:43:08 AM]: Debug: [SharedServices1_Search_DB] Database status is 65544.[10/3/2007 7:43:08 AM]: Verbose: [SharedServices1_Search_DB] SQL Server Command: SELECT TOP 1 1 FROM [SharedServices1_Search_DB]..sysobjects[10/3/2007 7:43:08 AM]: Verbose: [SharedServices1_Search_DB] Database restoration has been verified.[10/3/2007 7:43:08 AM]: Progress: [Shared Search Index] 90 percent complete.[10/3/2007 7:44:39 AM]: Progress: [Shared Search Index] 100 percent complete.[10/3/2007 7:44:40 AM]: Verbose: Starting object: SharedServices1_Search_DB.[10/3/2007 7:44:40 AM]: Verbose: Starting object: Global Search Settings.[10/3/2007 7:44:40 AM]: Progress: [Global Search Settings] 100 percent complete.[10/3/2007 7:44:41 AM]: Verbose: Starting object: Windows SharePoint Services Search.[10/3/2007 7:44:41 AM]: Progress: [Windows SharePoint Services Search] 100 percent complete.[10/3/2007 7:44:42 AM]: Verbose: Starting object: Search instance.[10/3/2007 7:44:43 AM]: Verbose: Current object: WSS_Search_CPI-MOSSWFE2-CH (previous name: WSS_Search_CPI-MOSS-WFE1).[10/3/2007 7:44:43 AM]: Verbose: Notifying third parties that the restore completed.[10/3/2007 7:44:44 AM]: Verbose: The IIS Web Site has been extended. You may need to use iisreset.exe to restart IIS before your site becomes accessible.[10/3/2007 7:44:44 AM]: Finish Time: 10/3/2007 7:44:44 AM.[10/3/2007 7:44:44 AM]: Progress: Completed with errors, please refer to the log file for details.[10/3/2007 7:44:45 AM]: Completed with 0 warnings.[10/3/2007 7:44:45 AM]: Completed with 2 errors.[10/3/2007 7:47:17 AM]: Restore failed for Object WSS_Content failed in event OnPostRestore. For more information, see the error log located in the backup directory.[10/3/2007 7:47:17 AM]: -------------------------------------------------

Solution for this problem is http://mossgeek.blogspot.com/ Thannks

Thanks for the reply, that sounds like it would have worked. I ended up creating a new Shared Services Provider and used a different port number and host header from the main portal application. I then moved the "My Sites" and main portal application over to the new Shared Services Provider. After I confirmed that everything was working, I deleted the old Shared Services Provider. The backup and restores are running beautifully now

There is probably a SSP which already exists on the server. You can try deleting the SSP and then delete the corresponding site and try again. You may want to ignore this and configure the SSP anyway?

Hi JP, This can happen if you delete web sites in inetmgr, rather than through the GUI. It doesn't cleanly remove IIS associations from the config database, so although you cannot see any web sites on inetmgr on your desired port/URL, they are still "in use" by SharePoint. The solution for me was to use the "Remove SharePoint from IIS Web Site" option on the Operations tab of Central Admin - this may work for you. Good luck, Poolio This worked for me as well. However, the "Remove Sharepoint from IIS Web site" option was under the Application Management section, not Operations. I'm runing WSS3.0, not MOSS, so that may be the difference.William W. Anderson