Sql-server – Mssql database old bakup restored on production server

sql serversql-server-2016

I am using mssql server 2016, I have accidentally restored the 24 hours old database backup file on production server, so I have lost the data for today, means I have lost the data of 24 hours, is there any chance I can get back my original database so that I can bring back the production database to original state, means before restoring the old database on production server.

Best Answer

is there any chance I can get back my original database so that I can bring back the production database to original state

There is NO possibility to do the UNDO/ROLLBACK action from the restore, you got only way to find recent backups that performed before restore operation.

Seems it's been more than 10 hours, if the database not in Full recovery mode and No Log backups, the translations whatever been posted during this 10 hours and happening now would be lost, i think you need quick action plan on this, without wasting time to find UNDO/ROLLBACK methods try to recover from recent backups by taking current state offline to avoid further lose.