Unsolved
This post is more than 5 years old
4 Posts
0
5123
Backup of Large SQL database timeout error
Hi,
We have a client running a SQL 2005 database server, one database of which is about 45 Gigabytes in size. We are getting continuing failures trying to backup the database using Avamar SQL agent. Other smaller databases on this server are backing up without issue.
The error output messages we get are as follows:
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at SMOWrap.SMO_ExecuteWithResults(SMOWrap* , Char* sql_cmd, vector \,std::allocator >\,std::allocator \,std::allocator > > >* messages) in c:\build workspace\nightly\rel40\ branch\avsql\smo\avsqlsmo.cpp:line 478
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute An exception occurred while executing a Transact-SQL statement or batch.
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.ProdName : Microsoft SQL Server
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.ProdVer : 09.00.3042
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.EvtSrc : MSSQLServer
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.EvtID : -2
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.LinkId : 20476
2009-04-20 03:27:23 avsql Info <7401>: physical: S:\Data\Argent_Data.MDF
2009-04-20 03:27:23 avsql Info <7402>: logical : Argent_Data
2009-04-20 03:27:23 avsql Info <7401>: physical: s:\Logs\Argent_Log.LDF
2009-04-20 03:27:23 avsql Info <7402>: logical : Argent_Log
2009-04-20 03:27:23 avsql Error <6773>: Unable to perform transfer
2009-04-20 03:27:29 avsql Info <6651>: Process 4132 (C:\Program Files\avs\bin\avtar) finished (code 536870925: Externally cancelled)
2009-04-20 03:27:29 avsql Warning <6653>: CTL workorder "Schedule - Daily 3am-Group - SQL DB - Meldb4-1240160400362#35" non-zero exit status 'code 536870925: Externally cancelled'
2009-04-20 03:27:31 avsql Info <6444>: Plugin exited with 'code 536870925: Externally cancelled'
2009-04-20 03:27:31 avsql Error <6784>: Unable to successfully process workorder Schedule - Daily 3am-Group - SQL DB - Meldb4-1240160400362#35, target (local)/Argent/f-0 because of inability to transfer data from SQL server
Are there any considerations that need to be made given that this is very large database? Any timeout values we can change?
I will have the client run an Index Reorganise to see if that can help.
Anyone been in this situation before?
Cheers,
Stefan.
We have a client running a SQL 2005 database server, one database of which is about 45 Gigabytes in size. We are getting continuing failures trying to backup the database using Avamar SQL agent. Other smaller databases on this server are backing up without issue.
The error output messages we get are as follows:
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at SMOWrap.SMO_ExecuteWithResults(SMOWrap* , Char* sql_cmd, vector \,std::allocator >\,std::allocator \,std::allocator > > >* messages) in c:\build workspace\nightly\rel40\ branch\avsql\smo\avsqlsmo.cpp:line 478
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute An exception occurred while executing a Transact-SQL statement or batch.
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.ProdName : Microsoft SQL Server
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.ProdVer : 09.00.3042
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.EvtSrc : MSSQLServer
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.EvtID : -2
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
2009-04-20 03:27:23 avsql Error <7403>: sqlconnectimpl_smo::execute HelpLink.LinkId : 20476
2009-04-20 03:27:23 avsql Info <7401>: physical: S:\Data\Argent_Data.MDF
2009-04-20 03:27:23 avsql Info <7402>: logical : Argent_Data
2009-04-20 03:27:23 avsql Info <7401>: physical: s:\Logs\Argent_Log.LDF
2009-04-20 03:27:23 avsql Info <7402>: logical : Argent_Log
2009-04-20 03:27:23 avsql Error <6773>: Unable to perform transfer
2009-04-20 03:27:29 avsql Info <6651>: Process 4132 (C:\Program Files\avs\bin\avtar) finished (code 536870925: Externally cancelled)
2009-04-20 03:27:29 avsql Warning <6653>: CTL workorder "Schedule - Daily 3am-Group - SQL DB - Meldb4-1240160400362#35" non-zero exit status 'code 536870925: Externally cancelled'
2009-04-20 03:27:31 avsql Info <6444>: Plugin exited with 'code 536870925: Externally cancelled'
2009-04-20 03:27:31 avsql Error <6784>: Unable to successfully process workorder Schedule - Daily 3am-Group - SQL DB - Meldb4-1240160400362#35, target (local)/Argent/f-0 because of inability to transfer data from SQL server
Are there any considerations that need to be made given that this is very large database? Any timeout values we can change?
I will have the client run an Index Reorganise to see if that can help.
Anyone been in this situation before?
Cheers,
Stefan.
OscarG1
2 Intern
2 Intern
•
137 Posts
1
April 21st, 2009 08:00