SatishReddy
Joined: 19 Jul 2007
Posts: 1
|
Posted:
Thu Jul 19, 2007 7:07 am Post subject:
unable to restore sps 2003 portal site |
|
|
When trying to restore a sps 2003 portal site,it is giving an error saying that the portal creation failed and could not upgrade the database.the log file shows the following.
㡀600070E8 00400000 11.0.8126.0DT3739-SATISHBK
Log Created on 07/18/07 16:26:58
07/18/07 16:26:58:234 UNK 00000000 00000AE4 Started Refreshing Collections
07/18/07 16:26:58:250 UNK 00000000 00000AE4 Finished Refreshing Collections
07/18/07 16:27:02:375 UNK 00000000 00000AE4 Started Refreshing Collections
07/18/07 16:27:02:375 UNK 00000000 00000AE4 Finished Refreshing Collections
07/18/07 16:27:04:937 UNK 00000000 00000AE4 Started Loading Components
07/18/07 16:27:04:953 UNK 00000000 00000AE4 Finished Loading Components
07/18/07 16:27:13:406 UNK 00000000 00000AE4 Started Refreshing Collections
07/18/07 16:27:13:406 UNK 00000000 00000AE4 Finished Refreshing Collections
07/18/07 16:27:13:547 UNK 00000000 00000AE4 Acquired search lock on server DT3739-SATISHBK at 2007/07/18 16:27:16
07/18/07 16:27:13:640 UNK 00000000 00001454 Monitor Progress Thread HeartBeat
07/18/07 16:27:13:672 UNK 00000000 00000B44 BackupSQL now in progress: Restore=True, Server=DT3739-SATISHBK, Database=PreSales2_SITE, Path=C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_SITE.SPB
07/18/07 16:27:13:672 CRI 00000000 00000B44 SQL Restore called with Server=DT3739-SATISHBK, Database=PreSales2_SITE, BackupPath=[C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_SITE.SPB], Percent=5
07/18/07 16:27:13:687 CRI 00000000 00000B44 Connecting to SQL Server DT3739-SATISHBK ...
07/18/07 16:27:13:703 CRI 00000000 00000B44 Connected to SQL Server DT3739-SATISHBK
07/18/07 16:27:13:703 CRI 00000000 00000B44 Connected To Server
07/18/07 16:27:13:703 CRI 00000000 00000B44 Entering RestoreDB for database PreSales2_SITE ...
07/18/07 16:27:13:703 CRI 00000000 00000B44 Entered Critical Section in RestoreDB for database PreSales2_SITE ...
07/18/07 16:27:13:703 CRI 00000000 00000B44 Left Critical Section in RestoreDB for database PreSales2_SITE ...
07/18/07 16:27:13:703 CRI 80045510 00000B44 GetDatabaseByName Failed. Trying to obtain path from master database.
07/18/07 16:27:13:750 CRI 00000000 00000B44 Command Text sent to SQL is: RESTORE DATABASE [PreSales2_SITE] FROM DISK = N'C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_SITE.SPB' WITH FILE = 1, NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE N'PreSales2_SITE' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_SITE_Data.MDF', MOVE N'PreSales2_SITE_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_SITE_Log.LDF'
07/18/07 16:27:13:765 CRI 00000000 00000B44 Database PreSales2_SITE does not exist, proceeding to restore it.
07/18/07 16:27:13:765 CRI 00000000 00000B44 Restoring database PreSales2_SITE ...
07/18/07 16:28:43:343 CRI 00000000 00000B44 Restore of database PreSales2_SITE COMPLETED
07/18/07 16:28:43:359 CRI 00000000 00000B44 Database PreSales2_SITE Returned successfully to multi-user state
07/18/07 16:28:43:359 CRI 00000000 00000B44 SQL Restore called with Server=DT3739-SATISHBK, Database=PreSales2_PROF, BackupPath=[C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_PROF.SPB], Percent=5
07/18/07 16:28:43:359 CRI 00000000 00000B44 Connecting to SQL Server DT3739-SATISHBK ...
07/18/07 16:28:43:359 CRI 00000000 00000B44 Connected to SQL Server DT3739-SATISHBK
07/18/07 16:28:43:359 CRI 00000000 00000B44 Connected To Server
07/18/07 16:28:43:359 CRI 00000000 00000B44 Entering RestoreDB for database PreSales2_PROF ...
07/18/07 16:28:43:359 CRI 00000000 00000B44 Entered Critical Section in RestoreDB for database PreSales2_PROF ...
07/18/07 16:28:43:359 CRI 00000000 00000B44 Left Critical Section in RestoreDB for database PreSales2_PROF ...
07/18/07 16:28:43:375 CRI 80045510 00000B44 GetDatabaseByName Failed. Trying to obtain path from master database.
07/18/07 16:28:43:406 CRI 00000000 00000B44 Command Text sent to SQL is: RESTORE DATABASE [PreSales2_PROF] FROM DISK = N'C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_PROF.SPB' WITH FILE = 1, NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE N'PreSales2_PROF' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_PROF_Data.MDF', MOVE N'PreSales2_PROF_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_PROF_Log.LDF'
07/18/07 16:28:43:406 CRI 00000000 00000B44 Database PreSales2_PROF does not exist, proceeding to restore it.
07/18/07 16:28:43:406 CRI 00000000 00000B44 Restoring database PreSales2_PROF ...
07/18/07 16:28:50:703 CRI 00000000 00000B44 Restore of database PreSales2_PROF COMPLETED
07/18/07 16:28:50:703 CRI 00000000 00000B44 Database PreSales2_PROF Returned successfully to multi-user state
07/18/07 16:28:50:703 CRI 00000000 00000B44 SQL Restore called with Server=DT3739-SATISHBK, Database=PreSales2_SERV, BackupPath=[C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_SERV.SPB], Percent=5
07/18/07 16:28:50:703 CRI 00000000 00000B44 Connecting to SQL Server DT3739-SATISHBK ...
07/18/07 16:28:50:718 CRI 00000000 00000B44 Connected to SQL Server DT3739-SATISHBK
07/18/07 16:28:50:718 CRI 00000000 00000B44 Connected To Server
07/18/07 16:28:50:718 CRI 00000000 00000B44 Entering RestoreDB for database PreSales2_SERV ...
07/18/07 16:28:50:718 CRI 00000000 00000B44 Entered Critical Section in RestoreDB for database PreSales2_SERV ...
07/18/07 16:28:50:718 CRI 00000000 00000B44 Left Critical Section in RestoreDB for database PreSales2_SERV ...
07/18/07 16:28:50:734 CRI 80045510 00000B44 GetDatabaseByName Failed. Trying to obtain path from master database.
07/18/07 16:28:50:765 CRI 00000000 00000B44 Command Text sent to SQL is: RESTORE DATABASE [PreSales2_SERV] FROM DISK = N'C:\Documents and Settings\M1003857\Desktop\Backup18-07\Backup18-07-DT1599-SERVER1-PreSales2_SERV.SPB' WITH FILE = 1, NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE N'PreSales2_SERV' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_SERV_Data.MDF', MOVE N'PreSales2_SERV_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\PreSales2_SERV_Log.LDF'
07/18/07 16:28:50:765 CRI 00000000 00000B44 Database PreSales2_SERV does not exist, proceeding to restore it.
07/18/07 16:28:50:765 CRI 00000000 00000B44 Restoring database PreSales2_SERV ...
07/18/07 16:29:10:703 CRI 00000000 00000B44 Restore of database PreSales2_SERV COMPLETED
07/18/07 16:29:10:703 CRI 00000000 00000B44 Database PreSales2_SERV Returned successfully to multi-user state
07/18/07 16:29:10:781 UNK 00000000 00000B44 The ensureNtlm parameter is true, therefore we will change the integrated authentication bindings to NTLM for the vserver
07/18/07 16:29:10:984 UNK 00000000 00000B44 Values used for restore: PortalUrl=http://dt3739-satishbk:1807/ Virtual Server Url=http://dt3739-satishbk:1807/ PortalName=PreSalesPortalNet Application Pool=MSSharePointPortalAppPool, user=DT3739-satishbk\Administrator SiteDB=(DT3739-SATISHBK, PreSales2_SITE) ProfileDB=(DT3739-SATISHBK, PreSales2_PROF) ServiceDB=(DT3739-SATISHBK, PreSales2_SERV)
07/18/07 16:29:10:984 UNK 00000000 00000B44 Original values recovered: SiteCountWarning=9000 SiteCountLimit=15000 OriginalPortalUrl=http://presalesnet.mindtree.com/ OriginalWorkspaceUrl= PortalWasFederated=FALSE PortalWasCentral=FALSE
07/18/07 16:29:11:187 UNK 00000000 00000B44 Defaulting the m_EnsureNtlm parameter is true, therefore we will change the integrated authentication bindings to NTLM for the vserver
07/18/07 16:29:11:187 UNK 00000000 00000B44 uHost set as: http://dt3739-satishbk:1807/
07/18/07 16:29:11:187 UNK 00000000 00000B44 Retrieving identity for application pool 'MSSharePointPortalAppPool'.
07/18/07 16:29:11:187 UNK 00000000 00000B44 Application pool identity is 'DT3739-satishbk\Administrator'.
07/18/07 16:29:11:187 UNK 00000000 00000B44 Virtual server Uri is 'http://dt3739-satishbk:1807/'
07/18/07 16:29:11:187 UNK 00000000 00000B44 Opening virtual server.
07/18/07 16:29:11:187 UNK 00000000 00000B44 Checking virtual server state.
07/18/07 16:29:11:203 UNK 00000000 00000B44 Virtual server needs extend.
07/18/07 16:29:11:203 UNK 00000000 00000B44 Extending virtual server 'http://dt3739-satishbk:1807/' using existing AppPool 'MSSharePointPortalAppPool'...
07/18/07 16:29:11:203 UNK 00000000 00000B44 The m_EnsureNtlm member is true, therefore we will change the integrated authentication bindings to NTLM for the vserver
07/18/07 16:29:12:328 UNK 00000000 00000B44 Virtual server extended.
07/18/07 16:29:12:328 UNK 00000000 00000B44 Checking if Document management exclusions are needed.
07/18/07 16:29:12:328 UNK 00000000 00000B44 Start- Recovering original virtual server properties
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: dead-site-num-notifications, Value=4
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: alerts-enabled, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: virtualserverpermsmask, Value=-1
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: emailinsertspublicfolderurl, Value=http://mtv01ex01/Presalesnet/
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: dead-site-notify-after, Value=90
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: alerts-maximum, Value=100
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: eventhandlersenabled, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: ssc-contact, Value=no
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: send-ad-email, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: job-email-enabled-lists, Value=every 5 minutes between 0 and 59
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: securityvalidation-enabled, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: max-file-post-size, Value=50
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: spallowp2p, Value=1
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: securityvalidation-expire, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: emailinsertsenabled, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: dead-site-auto-delete, Value=no
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: delete-web-send-email, Value=no
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: data-retrieval-services-inherit, Value=True
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: securityvalidation-timeout, Value=30
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: defaultquotatemplate, Value=No Quota
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: spallowglobalcatalog, Value=1
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: presenceenabled, Value=yes
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: data-retrieval-services-oledb-providers, Value=DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: ssc, Value=yes
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: job-dead-site-delete, Value=weekly at Sat 0:00:00
07/18/07 16:29:12:328 UNK 00000000 00000B44 Recovering Property: alerts-limited, Value=False
07/18/07 16:29:12:328 UNK 00000000 00000B44 End- Recovering original virtual server properties
07/18/07 16:29:12:328 UNK 00000000 00000B44 Start- Recovering original virtual server prefixes
07/18/07 16:29:13:328 UNK 00000000 00000B44 Start- spVirtualServer.Config.Prefixes.Add(personal, 1)
07/18/07 16:29:13:328 UNK 00000000 00000B44 End- spVirtualServer.Config.Prefixes.Add(personal, 1)
07/18/07 16:29:13:343 UNK 00000000 00000B44 End- Recovering original virtual server prefixes
07/18/07 16:29:13:422 UNK 00000000 00000B44 Portal creation failed Microsoft.SharePoint.SPException: Could not upgrade the database. ---> System.Runtime.InteropServices.COMException (0x81071543): Could not upgrade the database. at Microsoft.SharePoint.Library.SPRequestInternalClass.SetContentDatabaseMetainfo(Guid& gDatabaseId, Int32 lIISInstanceID, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, Int32& plCurrentSiteCount, Int32 lWarningSiteCount, Int32 lMaximumSiteCount, Int32 lStatus) at Microsoft.SharePoint.Library.a.a(Guid& A_0, Int32 A_1, String A_2, String A_3, String A_4, String A_5, Int32& A_6, Int32 A_7, Int32 A_8, Int32 A_9) --- End of inner exception stack trace --- at Microsoft.SharePoint.Library.a.a(Guid& A_0, Int32 A_1, String A_2, String A_3, String A_4, String A_5, Int32& A_6, Int32 A_7, Int32 A_8, Int32 A_9) at Microsoft.SharePoint.Administration.SPContentDatabase.Update() at Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(String strDatabaseServer, String strDatabaseName, String strDatabaseUsername, String strDatabasePassword, Int32 nWarningSiteCount, Int32 nMaximumSiteCount, Int32 nStatus) at Microsoft.SharePoint.Portal.Admin.c.f()
07/18/07 16:29:13:422 UNK 00000000 00000B44 Unextending virtual server 'http://dt3739-satishbk:1807/'. (ef688a09-a313-4ae6-911d-84eadeaf45e9)
07/18/07 16:29:13:750 UNK 00000000 00000B44 Removing virtual server 'Presales18-07' from configuration database. (ef688a09-a313-4ae6-911d-84eadeaf45e9)
07/18/07 16:29:13:750 UNK 00000000 00000B44 Exception creating portal. Microsoft.SharePoint.SPException: Could not upgrade the database. ---> System.Runtime.InteropServices.COMException (0x81071543): Could not upgrade the database. at Microsoft.SharePoint.Library.SPRequestInternalClass.SetContentDatabaseMetainfo(Guid& gDatabaseId, Int32 lIISInstanceID, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, Int32& plCurrentSiteCount, Int32 lWarningSiteCount, Int32 lMaximumSiteCount, Int32 lStatus) at Microsoft.SharePoint.Library.a.a(Guid& A_0, Int32 A_1, String A_2, String A_3, String A_4, String A_5, Int32& A_6, Int32 A_7, Int32 A_8, Int32 A_9) --- End of inner exception stack trace --- at Microsoft.SharePoint.Portal.Admin.c.f() at Microsoft.SharePoint.Portal.Topology.PortalSite.Restore(String portalUrl, Uri virtualServerUri, String siteDatabaseServer, String siteDatabaseName, String profileDatabaseServer, String profileDatabaseName, String serviceDatabaseServer, String serviceDatabaseName)
07/18/07 16:29:13:765 UNK 00000000 00000B44 Error creating portal. Error=Microsoft.SharePoint.SPException: Could not upgrade the database. ---> System.Runtime.InteropServices.COMException (0x81071543): Could not upgrade the database. at Microsoft.SharePoint.Library.SPRequestInternalClass.SetContentDatabaseMetainfo(Guid& gDatabaseId, Int32 lIISInstanceID, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, Int32& plCurrentSiteCount, Int32 lWarningSiteCount, Int32 lMaximumSiteCount, Int32 lStatus) at Microsoft.SharePoint.Library.a.a(Guid& A_0, Int32 A_1, String A_2, String A_3, String A_4, String A_5, Int32& A_6, Int32 A_7, Int32 A_8, Int32 A_9) --- End of inner exception stack trace --- at Microsoft.SharePoint.Portal.Topology.PortalSite.Restore(String portalUrl, Uri virtualServerUri, String siteDatabaseServer, String siteDatabaseName, String profileDatabaseServer, String profileDatabaseName, String serviceDatabaseServer, String serviceDatabaseName) at Microsoft.SharePoint.Portal.BackupRemote.b.d()
07/18/07 16:29:13:765 UNK 00000000 00000B44 BackupSQL Thread setting its status to completed and exiting
07/18/07 16:29:14:047 UNK 00000000 000016E8 Portal site http://dt3739-satishbk:1807/ does not exist. INDEX cannot be restored
07/18/07 16:29:15:562 UNK 00000000 00000AE4 Released search lock on server DT3739-SATISHBK
07/18/07 16:29:15:562 UNK 00000000 00001454 ProgressThread set completed status and is now exiting
07/18/07 16:29:15:765 UNK 00000000 00000AE4 Started Refreshing Collections
07/18/07 16:29:15:765 UNK 00000000 00000AE4 Finished Refreshing Collections
|
|