April 5, 2010 at 9:45 am
Hi,
We have SQL Server 2005 EE x64 with SP3 and configured log shipping for the databases. The log shipping backup job has failed for all the log ship configured databases with below error while the weekly DBCC CHECKDB maintenance task was running. And this setup is from several months but we got this error for the 1st time. Please advice
Message
2010-04-04 07:15:24.32*** Error: Could not retrieve backup settings for primary ID '1a84697b-4c07-4ae5-e221-ae5db92a2b0f'.(Microsoft.SqlServer.Management.LogShipping) ***
Message
2010-04-03 09:45:34.22*** Error: Failed to connect to server SQL1.(Microsoft.SqlServer.ConnectionInfo) ***
2010-04-03 09:45:34.22*** Error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: HTTP Provider, error: 0 - )(.Net SqlClient Data Provider) ***
April 6, 2010 at 1:50 am
It might be due to low memory while running DBCC CHECKDB. There is a chance that the sql server stop responding because of low memory & cause the log shipping job to fail..consider performing DBCC CHECKDB for large database separately & small databases separately on different days so that you can reduce resources usage on the server
hope this helps
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply