2000删除MSDB外键进行数据库备份记录删除.

USE MSDB
ALTER TABLE [backupset] drop CONSTRAINT FK__backupset__media__00200768;
ALTER TABLE [backupfile] drop CONSTRAINT FK__backupfil__backu__02FC7413;
ALTER TABLE [restorehistory] drop CONSTRAINT FK__restorehi__backu__05D8E0BE;
ALTER TABLE [restorefile] drop CONSTRAINT FK__restorefi__resto__07C12930;
ALTER TABLE [restorefilegroup] drop CONSTRAINT FK__restorefi__resto__09A971A2;
ALTER TABLE [backupmediafamily] drop CONSTRAINT FK__backupmed__media__7D439ABD;
GO
USE MSDB
truncate table backupfile

truncate table backupmediafamily

truncate table backupmediaset

truncate table backupset

truncate table restorefile

truncate table restorefilegroup

truncate table restorehistory
GO
USE MSDB
ALTER TABLE [backupset] add CONSTRAINT FK__backupset__media__00200768 FOREIGN KEY (media_set_id) REFERENCES backupmediaset(media_set_id);
ALTER TABLE [backupfile] add CONSTRAINT FK__backupfil__backu__02FC7413 FOREIGN KEY (backup_set_id) REFERENCES backupset(backup_set_id);
ALTER TABLE [restorehistory] add CONSTRAINT FK__restorehi__backu__05D8E0BE FOREIGN KEY (backup_set_id) REFERENCES backupset(backup_set_id);
ALTER TABLE [restorefile] add CONSTRAINT FK__restorefi__resto__07C12930 FOREIGN KEY (restore_history_id) REFERENCES restorehistory(restore_history_id);
ALTER TABLE [restorefilegroup] add CONSTRAINT FK__restorefi__resto__09A971A2 FOREIGN KEY (restore_history_id) REFERENCES restorehistory(restore_history_id);
ALTER TABLE [backupmediafamily] add CONSTRAINT FK__backupmed__media__7D439ABD FOREIGN KEY (media_set_id) REFERENCES backupmediaset(media_set_id);
go
dbcc shrinkdatabase('msdb')
go

转载于:https://www.cnblogs.com/anivie/archive/2011/04/21/2023685.html