删除快照还原创建的孤立记录 [英] Deleting orphan records created by Snapshot restore

问题描述

我的实例中有很多快照还原。因此，我看到有孤立的记录（公司ID为负）。

I have many snapshot restorations in my instance. Due to which I can see there are orphan records (with Company ID in negative).

它在很多表格上，而不仅仅是这张桌子。是否有流程或最佳实践来解决此问题？还是我们逐个表地运行删除脚本以对无效的公司标识进行记录。

It’s on many tables, not just this one. Is there a process or best practice to clean this out? Or do we go table by table to run delete scripts to records that are not valid companyid.

请提出建议。

推荐答案

您可以使用pp_DeleteCompany存储过程删除孤立快照。示例：EXEC pp_DeleteCompany -1234567（假设CompanyID为-1234567）

You can use the pp_DeleteCompany stored procedure to delete the orphan snapshots. Example: EXEC pp_DeleteCompany -1234567 (assuming the CompanyID is -1234567)

这篇关于删除快照还原创建的孤立记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！