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.
-
probably you have a good question, but you are in the wrong place. You can ask the administration community, StackOverflow is for coding queries.– Kiran ManiyaCommented Sep 14, 2019 at 19:14
-
3Do you have a recent Full backup? Do you have transaction log backups? Do you have any more recent system backups? Do you have your resume in good order?– David Browne - MicrosoftCommented Sep 14, 2019 at 22:06
-
i hope you have your tansaction log backups Read this from ms learn.microsoft.com/de-de/sql/relational-databases/logs/…– nbkCommented Sep 14, 2019 at 22:36
-
Does your System Admin team have a snapshot of the disks or the entire machine prior to the restore?– nkdbajoeCommented Sep 15, 2019 at 10:53
Add a comment
|
2 Answers
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.
answered Sep 15, 2019 at 5:44
You can't undo restore like it did not happen in the first place normally, but if you have a transaction log you can revert to the time before you replaced your database. or use a recent backup, this will minimize date lose.
answered Sep 15, 2019 at 9:00
