You don’t need to use a file for the delete records, you have a memory resident recordset which you can loop through, could then output this status to a log...

ok, but as suggested by others why dont you just connect directly to the source first, build your recordset and then connect to the target and perform whatever work needs...

This is the snippet from script. The serverInstance and Query both use servers that have the Dash(-) in their names.

stopwatch = [System.Diagnostics.Stopwatch]::StartNew()
# Define your SQL Server...

Azure SQLDB or Azure SQL Managed Instance?

Vdis can be started and disposed to meet dev requirements

Hi,

we check our databases every day with dbcc. If you got an...

Why use sql auth and not windows auth?

You also need to bear in mind that even after decrypting the database and dropping the encryption key and cert it is still possible part of the transaction log is...

Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues

Put delete triggers on...

again VDI will be best

Virtual desktop infrastructure is a common usage for exactly this, it keeps the organisation’s data where it should be and still easily accessible to those who have dev and test...

Original DBCC CHECKDB output would be helpful, with no outputs available would be safe to say data loss is unknown

if you knew what table(s) or index(es) were affected could restore...

Paul Randal details backup with checksum on this blog

https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2730-use-backup-with-checksum-to-replace-dbcc-checkdb/

What errors did checkdb report?

how often do you run dbcc checkdb on your databases?

My database was in suspect mode, and when I checked using DBCC CHECKDB, it returned errors.

As mentioned in the link below, I used the REPAIR_ALLOW_DATA_LOSS option with the DBCC...