One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod.
Now in the backupset table (
msdb.dbo.backupset) on prod, I can see a record for the dev database, with a backup start date time of when the restore was done.
Record from prod backupset table:
name: DatabaseName_UAT-Full Database Backup server_name: COMPNAME-SQLDEV02 machine_name: COMPNAME-SQLDEV02
I would not expect to see this record. Can anyone explain why restore would insert into the backupset table on prod?
Can I delete this record from the
msdb.dbo.backupset table? Or not such a good idea?