{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 对你真心纯属浪费 的问题《Deleting orphan records created by Snapshot restor》','https://www.manongdao.com/q-1024669.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.
Please suggest.
You can use the pp_DeleteCompany stored procedure to delete the orphan snapshots. Example: EXEC pp_DeleteCompany -1234567 (assuming the CompanyID is -1234567)