I need your help on restoring previous version of database on SQL Server.

In last week I restored database 'A' in DEV server with it's production copy and didn't realize that this database 'A' in DEV was not backed up and there was some already development work going on which is lost now!

Is there anyway of restoring previous version of 'A' database in DEV server?

Any help or suggestion would be really great!

Thank you!

  • Does your storage team take server level backups or SAN snaps etc? – George.Palacios Jul 4 '19 at 14:22
  • Not Sure! It's entire team who manages day to day incidents and possibly backup! I can ask them! – user2040021 Jul 4 '19 at 14:28
  • 1
    Give it a go - if they can restore the disk that the mdf file was on, you might have a shot. – George.Palacios Jul 4 '19 at 14:39

If database is restored on dev server and database backup was not scheduled to run on the dev server meaning no backup file is available for previously running database then, there is no way you can recover the previous database.

You may possibly ask your development team to re-deploy the things again for SQL code. Possibly, this would be learning to scheduled backup on dev server also based on the required frequency(daily/weekly).

| improve this answer | |
  • you are right, unfortunately no backup was done by developer ..and when I restored I wanted to restored with some different name but since PROD and DEV was the same name by default it took 'A' database and restored work in progress database. do you thin there will be some log files or something where we can retrieve important tables? – user2040021 Jul 4 '19 at 14:17
  • No there is no way to restore without a previous backup, or disk snapshot. Transaction log files do not work that way. – Randolph West Jul 4 '19 at 18:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.