SQL SERVER 2005删除维护作业报错:The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_jo
分类:MSSQL基础
下面是网上找的一些资料来解决这个问题: 先获取这个job_id:
USE [msdb]GO/****** Object: Job [dbbackup_diff.Subplan_1] Script Date: 04/08/2015 10:22:46 ******/EXEC msdb.dbo.sp_delete_job @job_id=N’588acfb8-630b-41c3-aa47-90d3671bda90′, @delete_unused_schedule=1GO
根据job_id到subplan_id:
select subplan_id FROM msdb.dbo.sysmaintplan_subplans where job_id=’588acfb8-630b-41c3-aa47-90d3671bda90’subplan_idFE56B397-4704-4AA7-BE49-767C1574E7D0
从系统表msdb.dbo.sysmaintplan_log和msdb.dbo.sysmaintplan_subplans中分别删除subplan_id为‘FE56B397-4704-4AA7-BE49-767C1574E7D0’的记录:
delete from msdb.dbo.sysmaintplan_log where subplan_id=’FE56B397-4704-4AA7-BE49-767C1574E7D0’delete FROM msdb.dbo.sysmaintplan_subplans WHERE SUBPLAN_ID=’FE56B397-4704-4AA7-BE49-767C1574E7D0′
再次回到图形界面再删除job就不会报错了。
参考:
上一篇Warning. Log sequence in archive filename wrapped to fix length as indicated by %S in LOG_ARCHIVE_F下一篇The transaction log for database 'xx' is full,Error: 9002, Severity: 17, State: 2
顶0踩0
,可是,我却迈不开步伐,怎么也走不出那个圈……