Hi, I am having moss2007 production server.I am taking backup of site using command. My command is C:/Program files/common files/Microsoft shared/Web Server Extension/12/BIN/stsadm -o backup -url http://fsplintranet/ -filename \\192.168.0.56\image\backup.dat When i run this command backup process starts, but after some time it terminates. Showing error is: Action cannot be completed, Please try again. Please suggest how to complete this backup. Thanks in advance.Regards urvinit

Did you try to create the backup in the local drive? Also refer to the following post http://social.technet.microsoft.com/Forums/vi-VN/sharepointadmin/thread/5cb17a56-6fa4-4220-9d6d-4620fd03074f--Cheers

I have tried in local drive, but still getting same error. actually my database size is large approximately 8 GB. In my local drive there is not enough free space so i am taking on network drive.Regards urvinit

Hi, As far as i remember, Either it is permission issue of your network folder or database server service issue (which i don't really remember right now). Make sure that your network drive folder has the full permission of that account, which you are using while taking the backup. Make sure that your account has proper permission of database server too. I will suggest that, First try to take the back up from central admin and let us know your resultCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Hi Hemendra, As you suggested, I have taken back up from central admin, its completed successfully,but when i am trying to restore it from central admin, I got an error and restoration fails. the error in 'sprestore' file is: [4/7/2011 6:24:17 PM]: Verbose: Adding Navigate_contentdb to Restore list. [4/7/2011 6:24:31 PM]: Progress: Starting Restore. [4/7/2011 6:24:31 PM]: Start Time: 4/7/2011 6:24:31 PM. [4/7/2011 6:24:31 PM]: Verbose: Requested by MOSS\Administrator. [4/7/2011 6:24:31 PM]: Verbose: Backup/Restore Settings: Restore Backup Method: Full Top Component: Farm\Windows SharePoint Services Web Application\SharePoint - fsplintranet80\Navigate_contentdb Directory: C:\IntranetBackup Progress updated: 5 [4/7/2011 6:24:31 PM]: Restore Method: New Backup ID: 891289c1-ee93-4d14-af4f-21736d545c4b Preserve content database change log: False [4/7/2011 6:24:31 PM]: Verbose: Starting OnRestore event. [4/7/2011 6:24:31 PM]: Verbose: Starting object: Navigate_contentdb. [4/7/2011 6:24:31 PM]: Verbose: [Navigate_contentdb] SQL Server Connection String: Data Source=fsplintranet.moss.com;Initial Catalog=Navigate_contentdb;Integrated Security=True. [4/7/2011 6:24:46 PM]: Error: Object Navigate_contentdb failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) [4/7/2011 6:24:46 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.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) 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) [4/7/2011 6:24:46 PM]: Verbose: Starting OnPostRestore event. [4/7/2011 6:24:46 PM]: Verbose: Notifying third parties that the restore completed. [4/7/2011 6:24:46 PM]: Verbose: The IIS Web Site has been extended. You may need to use iisreset.exe to restart IIS before your site becomes accessible. [4/7/2011 6:24:46 PM]: Finish Time: 4/7/2011 6:24:46 PM. [4/7/2011 6:24:46 PM]: Progress: Completed with errors, please refer to the log file for details. [4/7/2011 6:24:46 PM]: Verbose: Deleting the file C:\IntranetBackup\spbr0000\sprestore.xml and replacing it. [4/7/2011 6:24:46 PM]: Verbose: The backup/restore process included the following objects: [4/7/2011 6:24:46 PM]: *Farm\ *[SharePoint_Config]\ *Windows SharePoint Services Web Application\ *SharePoint - 8081\ *WSS_Content_Mysite\ *SharePoint - fsplintranet80\ *Navigate_contentdb\ *[WSS_Administration]\ *[Web Application]\ *[SharePoint_AdminContent_e7287ac6-ada1-46a3-8c65-b3721a957cee]\ *SharedServices1\ *[SharePoint - 8080]\ *WSS_Content_SSP\ *[SharedServices1_DB]\ *[UserProfileApplication]\ *[SessionStateSharedApplication]\ *[Shared Search Index]\ *[SharedServices1_Search_DB]\ *Global Search Settings\ *Windows SharePoint Services Help Search\ *[Search instance]\ *[WSS_Search_FSPL-MOSS01]\ [4/7/2011 6:24:46 PM]: Completed with 0 warnings. [4/7/2011 6:24:46 PM]: Completed with 1 errors. [4/7/2011 6:24:58 PM]: Restore failed for Object Navigate_contentdb failed in event OnRestore. For more information, see the error log located in the backup directory. [4/7/2011 6:24:58 PM]: ------------------------------------------------- Regards urvinit

>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections Check the below points: 1. Make sure that you are passing right DB server name / IP 2. Make sure that User should have admin permission of your database server to create the new database Hope we could able to resolve itCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"