Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error in maintenance plan history cleanup task (exec msdb.dbo.sp_delete_backuphistory) Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 1:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:54 AM
Points: 168, Visits: 674
Hello Friends,

I got one Strange Error

"Executing the query "declare @dt datetime select @dt = cast(N'2013-10-11T14:40:53' as datetime) exec msdb.dbo.sp_delete_backuphistory @dt

" failed with the following error: "The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."


i was tried DBCC opentran(No Active transactions) and sys.dm_os_waiting_tasks and tran_locks also but no useful.
Environment Sql server 2005 ram Total 3GB SQL is 2.5GB Allocated for Sql server and i.e.,currently Log Shipping Primary database server .

Kindly help me on this ...

Thanks in advance.

Thanks& Regards,
DBA



SQL server DBA
Post #1521771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse