Backup and Restore from the Central Administration 3.0

S

Sam

I know how to backup and restore from the central administration 3.0.
but after backup when i tried to restore in the virtual machine which has
fresh complete installation of EPM2007. the errors are displaying in the
status column.
the database which i want to restore are 16 . and fresh installation
databases are 13 . may be some port differences .
and this is log file which the restore has been created.


[1/6/2009 2:08:34 PM]: Verbose: Using directory: c:\a\spbr0000\.
[1/6/2009 2:08:34 PM]: Verbose: Starting OnPreRestore event.

[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:46 PM]: Verbose: Using directory: c:\a\spbr0000\.

[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:12:58 PM]: Farm\
[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
WSS_Content\
[WSS_Administration]\
[Web Application]\

[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
WSS_Content_SSP90\
[SSP90_DB]\
Project Server Application\
PWA\
ProjectServer_Published\
ProjectServer_Draft\
ProjectServer_Archive\
ProjectServer_Reporting\
[SessionStateSharedApplication]\

[1/6/2009 2:13:00 PM]: Progress: Starting Restore.
[1/6/2009 2:13:00 PM]: Start Time: 1/6/2009 2:13:00 PM.
[1/6/2009 2:13:00 PM]: Verbose: Requested by VM\Administrator.
[1/6/2009 2:13:00 PM]: Verbose: Backup/Restore Settings:
Restore
Backup Method: Full
Top Component: Farm
Directory: c:\a
Progress updated: 5
[1/6/2009 2:13:00 PM]: Restore Method: Overwrite
Backup ID: ff5b9f99-48f9-40b5-a1b3-9f51100f9d2a

[1/6/2009 2:13:00 PM]: Verbose: Starting OnRestore event.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Farm.
[1/6/2009 2:13:00 PM]: Verbose: [Farm] The configuration database and
central administration content database components cannot be restored.
[1/6/2009 2:13:00 PM]: Progress: [Farm] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Windows SharePoint Services
Web Application.
[1/6/2009 2:13:00 PM]: Progress: [Windows SharePoint Services Web
Application] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: PWA - 80.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Trying to connect to Web
application http://epm2007/.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Creating a new Web application.
[1/6/2009 2:13:11 PM]: Verbose: [PWA - 80] Provisioning a new Web application.
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:13:27 PM]: Progress: [PWA - 80] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Content.
[1/6/2009 2:13:27 PM]: Verbose: [WSS_Content] SQL Server Connection String:
Data Source=EPM2007;Initial Catalog=WSS_Content;Integrated Security=True.
[1/6/2009 2:13:27 PM]: Error: Object WSS_Content failed in event OnRestore.
For more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:13:27 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Administration.
[1/6/2009 2:13:27 PM]: Progress: [WSS_Administration] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 10 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 30 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 40 percent complete.
[1/6/2009 2:14:43 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:43 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Trying to connect to Web
application http://epm2007:90/.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Creating a new Web application.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Provisioning a new Web application.
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:14:56 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:56 PM]: Verbose: Starting object: WSS_Content_SSP90.
[1/6/2009 2:14:56 PM]: Verbose: [WSS_Content_SSP90] SQL Server Connection
String: Data Source=EPM2007;Initial Catalog=WSS_Content_SSP90;Integrated
Security=True.
[1/6/2009 2:14:56 PM]: Error: Object WSS_Content_SSP90 failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:56 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:56 PM]: Verbose: Starting object: SSP90_DB.
[1/6/2009 2:14:56 PM]: Verbose: [SSP90_DB] SQL Server Connection String:
Data Source=EPM2007;Initial Catalog=SSP90_DB;Integrated Security=True.
[1/6/2009 2:14:56 PM]: Error: Object SSP90_DB failed in event OnRestore. For
more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:56 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at Microsoft.Office.Server.Administration.SharedDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:57 PM]: Verbose: Starting object: Project Server Application.
[1/6/2009 2:14:57 PM]: Verbose: Starting object: PWA.
[1/6/2009 2:14:57 PM]: Progress: [PWA] 50 percent complete.
[1/6/2009 2:14:57 PM]: Verbose: Starting object: ProjectServer_Published.
[1/6/2009 2:14:57 PM]: Verbose: [ProjectServer_Published] SQL Server
Connection String: Data Source=EPM2007;Initial
Catalog=ProjectServer_Published;Integrated Security=True.
[1/6/2009 2:14:57 PM]: Error: Object ProjectServer_Published failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:57 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:57 PM]: Verbose: Starting object: ProjectServer_Draft.
[1/6/2009 2:14:57 PM]: Verbose: [ProjectServer_Draft] SQL Server Connection
String: Data Source=EPM2007;Initial Catalog=ProjectServer_Draft;Integrated
Security=True.
[1/6/2009 2:14:57 PM]: Error: Object ProjectServer_Draft failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection. at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)

at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication.CreateAdministrationTasks()
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication..ctor(SharedResourceProvider
sharedResourceProvider, ProjectApplicationService projectAppService)
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplicationCollection.Add(SharedResourceProvider sharedResourceProvider)
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication.OnPostRestore(Object sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Starting object: PWA.
[1/6/2009 2:15:00 PM]: FatalError: [PWA] Can't obtain
ProjectPSISharedApplication restoring ProjectSite 'PWA.
[1/6/2009 2:15:00 PM]: Error: Object PWA failed in event OnPostRestore. For
more information, see the error log located in the backup directory.
InvalidOperationException: ProjectSite.OnPostRestore
[1/6/2009 2:15:00 PM]: Debug: at
Microsoft.Office.Project.Server.Administration.ProjectSite.OnPostRestore(Object sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Starting object:
SessionStateSharedApplication.
[1/6/2009 2:15:00 PM]: Error: Object SessionStateSharedApplication failed in
event OnPostRestore. For more information, see the error log located in the
backup directory.
NullReferenceException: Object reference not set to an instance of an object.
[1/6/2009 2:15:00 PM]: Debug: at
Microsoft.Office.Server.Administration.SessionStateSharedApplication.InternalInstall(SharedResourceProvider sharedResourceProvider)
at
Microsoft.Office.Server.Administration.SessionStateSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnPostRestore(Object
sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Notifying third parties that the restore
completed.
[1/6/2009 2:15:00 PM]: Verbose: The IIS Web Site has been extended. You may
need to use iisreset.exe to restart IIS before your site becomes accessible.
[1/6/2009 2:15:00 PM]: Finish Time: 1/6/2009 2:15:00 PM.
[1/6/2009 2:15:00 PM]: Progress: Completed with errors, please refer to the
log file for details.
[1/6/2009 2:15:00 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:15:00 PM]: Farm\
*[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
*WSS_Content\
[WSS_Administration]\
*[Web Application]\

*[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
*WSS_Content_SSP90\
*[SSP90_DB]\
*Project Server Application\
*PWA\
*ProjectServer_Published\
*ProjectServer_Draft\
*ProjectServer_Archive\
*ProjectServer_Reporting\
*[SessionStateSharedApplication]\

[1/6/2009 2:15:00 PM]: Completed with 0 warnings.
[1/6/2009 2:15:00 PM]: Completed with 11 errors.
[1/6/2009 2:15:02 PM]: Restore failed for Object
SessionStateSharedApplication failed in event OnPostRestore. For more
information, see the error log located in the backup directory.
[1/6/2009 2:15:02 PM]: -------------------------------------------------
 
D

Dharmesh Patel

Hey Sam,

In my experience I would recommend performing a Full Database backup rather
than using the Central Admin Backup and Restore facility as I found this
does not always work.....

I am not too sure as to the issue that you are having below - but this does
seem similar to my issue and this was a result of the Central Admin Backup
and Restore.

Sorry I was not able to help any further with this....

Regards,

Dharmesh


Sam said:
I know how to backup and restore from the central administration 3.0.
but after backup when i tried to restore in the virtual machine which has
fresh complete installation of EPM2007. the errors are displaying in the
status column.
the database which i want to restore are 16 . and fresh installation
databases are 13 . may be some port differences .
and this is log file which the restore has been created.


[1/6/2009 2:08:34 PM]: Verbose: Using directory: c:\a\spbr0000\.
[1/6/2009 2:08:34 PM]: Verbose: Starting OnPreRestore event.

[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:46 PM]: Verbose: Using directory: c:\a\spbr0000\.

[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:12:58 PM]: Farm\
[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
WSS_Content\
[WSS_Administration]\
[Web Application]\

[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
WSS_Content_SSP90\
[SSP90_DB]\
Project Server Application\
PWA\
ProjectServer_Published\
ProjectServer_Draft\
ProjectServer_Archive\
ProjectServer_Reporting\
[SessionStateSharedApplication]\

[1/6/2009 2:13:00 PM]: Progress: Starting Restore.
[1/6/2009 2:13:00 PM]: Start Time: 1/6/2009 2:13:00 PM.
[1/6/2009 2:13:00 PM]: Verbose: Requested by VM\Administrator.
[1/6/2009 2:13:00 PM]: Verbose: Backup/Restore Settings:
Restore
Backup Method: Full
Top Component: Farm
Directory: c:\a
Progress updated: 5
[1/6/2009 2:13:00 PM]: Restore Method: Overwrite
Backup ID: ff5b9f99-48f9-40b5-a1b3-9f51100f9d2a

[1/6/2009 2:13:00 PM]: Verbose: Starting OnRestore event.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Farm.
[1/6/2009 2:13:00 PM]: Verbose: [Farm] The configuration database and
central administration content database components cannot be restored.
[1/6/2009 2:13:00 PM]: Progress: [Farm] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Windows SharePoint
Services
Web Application.
[1/6/2009 2:13:00 PM]: Progress: [Windows SharePoint Services Web
Application] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: PWA - 80.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Trying to connect to Web
application http://epm2007/.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Creating a new Web application.
[1/6/2009 2:13:11 PM]: Verbose: [PWA - 80] Provisioning a new Web
application.
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:13:27 PM]: Progress: [PWA - 80] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Content.
[1/6/2009 2:13:27 PM]: Verbose: [WSS_Content] SQL Server Connection
String:
Data Source=EPM2007;Initial Catalog=WSS_Content;Integrated Security=True.
[1/6/2009 2:13:27 PM]: Error: Object WSS_Content failed in event
OnRestore.
For more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:13:27 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at
Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Administration.
[1/6/2009 2:13:27 PM]: Progress: [WSS_Administration] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 10 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 30 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 40 percent complete.
[1/6/2009 2:14:43 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:43 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Trying to connect to Web
application http://epm2007:90/.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Creating a new Web application.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Provisioning a new Web
application.
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:14:56 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:56 PM]: Verbose: Starting object: WSS_Content_SSP90.
[1/6/2009 2:14:56 PM]: Verbose: [WSS_Content_SSP90] SQL Server Connection
String: Data Source=EPM2007;Initial Catalog=WSS_Content_SSP90;Integrated
Security=True.
[1/6/2009 2:14:56 PM]: Error: Object WSS_Content_SSP90 failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:56 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at
Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:56 PM]: Verbose: Starting object: SSP90_DB.
[1/6/2009 2:14:56 PM]: Verbose: [SSP90_DB] SQL Server Connection String:
Data Source=EPM2007;Initial Catalog=SSP90_DB;Integrated Security=True.
[1/6/2009 2:14:56 PM]: Error: Object SSP90_DB failed in event OnRestore.
For
more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:56 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at
Microsoft.Office.Server.Administration.SharedDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:57 PM]: Verbose: Starting object: Project Server
Application.
[1/6/2009 2:14:57 PM]: Verbose: Starting object: PWA.
[1/6/2009 2:14:57 PM]: Progress: [PWA] 50 percent complete.
[1/6/2009 2:14:57 PM]: Verbose: Starting object: ProjectServer_Published.
[1/6/2009 2:14:57 PM]: Verbose: [ProjectServer_Published] SQL Server
Connection String: Data Source=EPM2007;Initial
Catalog=ProjectServer_Published;Integrated Security=True.
[1/6/2009 2:14:57 PM]: Error: Object ProjectServer_Published failed in
event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:14:57 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:14:57 PM]: Verbose: Starting object: ProjectServer_Draft.
[1/6/2009 2:14:57 PM]: Verbose: [ProjectServer_Draft] SQL Server
Connection
String: Data Source=EPM2007;Initial Catalog=ProjectServer_Draft;Integrated
Security=True.
[1/6/2009 2:14:57 PM]: Error: Object ProjectServer_Draft failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection. at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)

at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication.CreateAdministrationTasks()
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication..ctor(SharedResourceProvider
sharedResourceProvider, ProjectApplicationService projectAppService)
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplicationCollection.Add(SharedResourceProvider
sharedResourceProvider)
at
Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication.OnPostRestore(Object
sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Starting object: PWA.
[1/6/2009 2:15:00 PM]: FatalError: [PWA] Can't obtain
ProjectPSISharedApplication restoring ProjectSite 'PWA.
[1/6/2009 2:15:00 PM]: Error: Object PWA failed in event OnPostRestore.
For
more information, see the error log located in the backup directory.
InvalidOperationException: ProjectSite.OnPostRestore
[1/6/2009 2:15:00 PM]: Debug: at
Microsoft.Office.Project.Server.Administration.ProjectSite.OnPostRestore(Object
sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Starting object:
SessionStateSharedApplication.
[1/6/2009 2:15:00 PM]: Error: Object SessionStateSharedApplication failed
in
event OnPostRestore. For more information, see the error log located in
the
backup directory.
NullReferenceException: Object reference not set to an instance of an
object.
[1/6/2009 2:15:00 PM]: Debug: at
Microsoft.Office.Server.Administration.SessionStateSharedApplication.InternalInstall(SharedResourceProvider
sharedResourceProvider)
at
Microsoft.Office.Server.Administration.SessionStateSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnPostRestore(Object
sender, SPRestoreInformation args)
[1/6/2009 2:15:00 PM]: Verbose: Notifying third parties that the restore
completed.
[1/6/2009 2:15:00 PM]: Verbose: The IIS Web Site has been extended. You
may
need to use iisreset.exe to restart IIS before your site becomes
accessible.
[1/6/2009 2:15:00 PM]: Finish Time: 1/6/2009 2:15:00 PM.
[1/6/2009 2:15:00 PM]: Progress: Completed with errors, please refer to
the
log file for details.
[1/6/2009 2:15:00 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:15:00 PM]: Farm\
*[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
*WSS_Content\
[WSS_Administration]\
*[Web Application]\

*[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
*WSS_Content_SSP90\
*[SSP90_DB]\
*Project Server Application\
*PWA\
*ProjectServer_Published\
*ProjectServer_Draft\
*ProjectServer_Archive\
*ProjectServer_Reporting\
*[SessionStateSharedApplication]\

[1/6/2009 2:15:00 PM]: Completed with 0 warnings.
[1/6/2009 2:15:00 PM]: Completed with 11 errors.
[1/6/2009 2:15:02 PM]: Restore failed for Object
SessionStateSharedApplication failed in event OnPostRestore. For more
information, see the error log located in the backup directory.
[1/6/2009 2:15:02 PM]: -------------------------------------------------
 
W

waqas sarwar

Hi

Under which system account you are performing this backup. Basically it must
be admin account and have the permission to access the DB also have the
ability to the write in the backup folder. It must be powerful user.
--
Waqas Sarwar
Sharepoint & Project Server Admin
MCTS(70-630,70-631,70-639).
VA, USA


Dharmesh Patel said:
Hey Sam,

In my experience I would recommend performing a Full Database backup rather
than using the Central Admin Backup and Restore facility as I found this
does not always work.....

I am not too sure as to the issue that you are having below - but this does
seem similar to my issue and this was a result of the Central Admin Backup
and Restore.

Sorry I was not able to help any further with this....

Regards,

Dharmesh


Sam said:
I know how to backup and restore from the central administration 3.0.
but after backup when i tried to restore in the virtual machine which has
fresh complete installation of EPM2007. the errors are displaying in the
status column.
the database which i want to restore are 16 . and fresh installation
databases are 13 . may be some port differences .
and this is log file which the restore has been created.


[1/6/2009 2:08:34 PM]: Verbose: Using directory: c:\a\spbr0000\.
[1/6/2009 2:08:34 PM]: Verbose: Starting OnPreRestore event.

[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:46 PM]: Verbose: Using directory: c:\a\spbr0000\.

[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:12:58 PM]: Farm\
[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
WSS_Content\
[WSS_Administration]\
[Web Application]\

[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
WSS_Content_SSP90\
[SSP90_DB]\
Project Server Application\
PWA\
ProjectServer_Published\
ProjectServer_Draft\
ProjectServer_Archive\
ProjectServer_Reporting\
[SessionStateSharedApplication]\

[1/6/2009 2:13:00 PM]: Progress: Starting Restore.
[1/6/2009 2:13:00 PM]: Start Time: 1/6/2009 2:13:00 PM.
[1/6/2009 2:13:00 PM]: Verbose: Requested by VM\Administrator.
[1/6/2009 2:13:00 PM]: Verbose: Backup/Restore Settings:
Restore
Backup Method: Full
Top Component: Farm
Directory: c:\a
Progress updated: 5
[1/6/2009 2:13:00 PM]: Restore Method: Overwrite
Backup ID: ff5b9f99-48f9-40b5-a1b3-9f51100f9d2a

[1/6/2009 2:13:00 PM]: Verbose: Starting OnRestore event.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Farm.
[1/6/2009 2:13:00 PM]: Verbose: [Farm] The configuration database and
central administration content database components cannot be restored.
[1/6/2009 2:13:00 PM]: Progress: [Farm] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Windows SharePoint
Services
Web Application.
[1/6/2009 2:13:00 PM]: Progress: [Windows SharePoint Services Web
Application] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: PWA - 80.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Trying to connect to Web
application http://epm2007/.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Creating a new Web application.
[1/6/2009 2:13:11 PM]: Verbose: [PWA - 80] Provisioning a new Web
application.
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:13:27 PM]: Progress: [PWA - 80] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Content.
[1/6/2009 2:13:27 PM]: Verbose: [WSS_Content] SQL Server Connection
String:
Data Source=EPM2007;Initial Catalog=WSS_Content;Integrated Security=True.
[1/6/2009 2:13:27 PM]: Error: Object WSS_Content failed in event
OnRestore.
For more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:13:27 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at
Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Administration.
[1/6/2009 2:13:27 PM]: Progress: [WSS_Administration] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 10 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 30 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 40 percent complete.
[1/6/2009 2:14:43 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:43 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Trying to connect to Web
application http://epm2007:90/.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Creating a new Web application.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Provisioning a new Web
application.
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:14:56 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:56 PM]: Verbose: Starting object: WSS_Content_SSP90.
[1/6/2009 2:14:56 PM]: Verbose: [WSS_Content_SSP90] SQL Server Connection
String: Data Source=EPM2007;Initial Catalog=WSS_Content_SSP90;Integrated
Security=True.
[1/6/2009 2:14:56 PM]: Error: Object WSS_Content_SSP90 failed in event
OnRestore. For more information, see the error log located in the backup
directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
 
S

Sam

I have done complete backup successfully.

Where you want to restore backup.
first make it in domain and login with the user with the administrator
rights and also in previous installation.
first install up to windows sharepoint central administration 3.0 .
then install "WSS 3.0 infrastructure update"
and start the "project application service" from wss 3.0 --?Operations --->
services on server
start the project server 2007 services (events and queue) and wss 3.0
services (timer)
and then restore the backup from WSS 3.0 with the new configuration.
if the "Access Denied" error .
then open the WSS 3.0 Central Administration. select the application
management and configure the both web application and change their
administrators with the user from which you are login and also that user
account exist in epm 2007 previous installation. which backup you are
restoring.

restore will be successfull and work.

waqas sarwar said:
Hi

Under which system account you are performing this backup. Basically it must
be admin account and have the permission to access the DB also have the
ability to the write in the backup folder. It must be powerful user.
--
Waqas Sarwar
Sharepoint & Project Server Admin
MCTS(70-630,70-631,70-639).
VA, USA


Dharmesh Patel said:
Hey Sam,

In my experience I would recommend performing a Full Database backup rather
than using the Central Admin Backup and Restore facility as I found this
does not always work.....

I am not too sure as to the issue that you are having below - but this does
seem similar to my issue and this was a result of the Central Admin Backup
and Restore.

Sorry I was not able to help any further with this....

Regards,

Dharmesh


Sam said:
I know how to backup and restore from the central administration 3.0.
but after backup when i tried to restore in the virtual machine which has
fresh complete installation of EPM2007. the errors are displaying in the
status column.
the database which i want to restore are 16 . and fresh installation
databases are 13 . may be some port differences .
and this is log file which the restore has been created.


[1/6/2009 2:08:34 PM]: Verbose: Using directory: c:\a\spbr0000\.
[1/6/2009 2:08:34 PM]: Verbose: Starting OnPreRestore event.

[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:08:35 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:46 PM]: Verbose: Using directory: c:\a\spbr0000\.

[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Farm to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SharePoint_Config to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Windows SharePoint Services Web
Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA - 80 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Administration to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Web Application to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding
SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP - 90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding WSS_Content_SSP90 to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SSP90_DB to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding Project Server Application to
Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding PWA to Restore list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Published to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Draft to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Archive to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding ProjectServer_Reporting to Restore
list.
[1/6/2009 2:12:58 PM]: Verbose: Adding SessionStateSharedApplication to
Restore list.
[1/6/2009 2:12:58 PM]: Verbose: The backup/restore process included the
following objects:
[1/6/2009 2:12:58 PM]: Farm\
[SharePoint_Config]\
Windows SharePoint Services Web Application\
PWA - 80\
WSS_Content\
[WSS_Administration]\
[Web Application]\

[SharePoint_AdminContent_8b471af1-4d37-4b4e-b3dd-79bb1d23c5be]\
SSP - 90\
[SSP - 90]\
WSS_Content_SSP90\
[SSP90_DB]\
Project Server Application\
PWA\
ProjectServer_Published\
ProjectServer_Draft\
ProjectServer_Archive\
ProjectServer_Reporting\
[SessionStateSharedApplication]\

[1/6/2009 2:13:00 PM]: Progress: Starting Restore.
[1/6/2009 2:13:00 PM]: Start Time: 1/6/2009 2:13:00 PM.
[1/6/2009 2:13:00 PM]: Verbose: Requested by VM\Administrator.
[1/6/2009 2:13:00 PM]: Verbose: Backup/Restore Settings:
Restore
Backup Method: Full
Top Component: Farm
Directory: c:\a
Progress updated: 5
[1/6/2009 2:13:00 PM]: Restore Method: Overwrite
Backup ID: ff5b9f99-48f9-40b5-a1b3-9f51100f9d2a

[1/6/2009 2:13:00 PM]: Verbose: Starting OnRestore event.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Farm.
[1/6/2009 2:13:00 PM]: Verbose: [Farm] The configuration database and
central administration content database components cannot be restored.
[1/6/2009 2:13:00 PM]: Progress: [Farm] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: Windows SharePoint
Services
Web Application.
[1/6/2009 2:13:00 PM]: Progress: [Windows SharePoint Services Web
Application] 50 percent complete.
[1/6/2009 2:13:00 PM]: Verbose: Starting object: PWA - 80.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Trying to connect to Web
application http://epm2007/.
[1/6/2009 2:13:00 PM]: Verbose: [PWA - 80] Creating a new Web application.
[1/6/2009 2:13:11 PM]: Verbose: [PWA - 80] Provisioning a new Web
application.
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.SharedResourceProvider], value = []
[1/6/2009 2:13:26 PM]: Verbose: [PWA - 80] WebApp
(8ac0cbf1-4ada-4fa4-b6e9-db5fba3cadc9): Adding propertiy
[Microsoft.Office.Server.IsParentSharedResourceProvider], value = [False]
[1/6/2009 2:13:27 PM]: Progress: [PWA - 80] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Content.
[1/6/2009 2:13:27 PM]: Verbose: [WSS_Content] SQL Server Connection
String:
Data Source=EPM2007;Initial Catalog=WSS_Content;Integrated Security=True.
[1/6/2009 2:13:27 PM]: Error: Object WSS_Content failed in event
OnRestore.
For more information, see the error log located in the backup directory.
SqlException: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.
[1/6/2009 2:13:27 PM]: Debug: at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.ConnectMaster()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreConnection.Connect()
at
Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation
args)
at
Microsoft.SharePoint.Administration.Backup.SPSqlRestoreHelper.Run(SPBackupRestoreInformation
args)
at Microsoft.SharePoint.Administration.SPDatabase.OnRestore(Object
sender, SPRestoreInformation info)
at
Microsoft.SharePoint.Administration.SPContentDatabase.OnRestore(Object
sender, SPRestoreInformation info)
[1/6/2009 2:13:27 PM]: Verbose: Starting object: WSS_Administration.
[1/6/2009 2:13:27 PM]: Progress: [WSS_Administration] 50 percent complete.
[1/6/2009 2:13:27 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 10 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 30 percent complete.
[1/6/2009 2:13:27 PM]: Progress: [SSP - 90] 40 percent complete.
[1/6/2009 2:14:43 PM]: Progress: [SSP - 90] 50 percent complete.
[1/6/2009 2:14:43 PM]: Verbose: Starting object: SSP - 90.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Trying to connect to Web
application http://epm2007:90/.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Creating a new Web application.
[1/6/2009 2:14:43 PM]: Verbose: [SSP - 90] Provisioning a new Web
application.
[1/6/2009 2:14:56 PM]: Verbose: [SSP - 90] WebApp
(743dcc6a-609b-4650-a4b2-19f5314c4d8a): Adding propertiy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top