SQLTeam.com | Weblogs | Forums

Archiving K2 DB


Trying to Archive a clients K2 DB, he receives this error.Using a Stored Procedure mArchive 1.5,tried to create new DB to archive to, get same result.Any help will be appreciated.
Error Occured:The DELETE statement conflicted with the REFERENCE constraint "FK_ServerLog_ProcInstComment_ProcInstID_ServerLog_ProcInst_ID". The conflict occurred in database "TIS_WF", table "ServerLog.ProcInstComment", column 'ProcInstID'. The statement has been terminated


There are values from the parent tables that are being referred in the child tables using the foreign keys.
First,you need to delete the record from the child table and then perform the delete on the parent table.