Restore previous version of database in sql server 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!
There is a chance if the answer to all the below questions is NO

Was the database name exactly identical in Prod and Dev?

When restoring Database A on the Dev server, did you explicitly choose to move the data and the log files to the same path (and overwrite them) where the original dev Database A resided?

Did you drop database A on the Dev box before restoring from the prod backup?


If the answer to all the above questions is No, then there is a chance that your restore did not overwrite the original files of database A on the dev server.
When restoring a database from a backup that was taken on a different server/DB, SQL Server creates data and log files on the same path as that of the original database (in your case prod copy of database A) that the backup belongs to (unless explicitly mentioned in the MOVE clause of the RESTORE command). So if the path of the data and log files on Prod is different from the Dev box, then the restore operation will not overwrite the files unless you explicitly specify WITH MOVE 'filename' TO 'path' in the restore command along with the option REPLACE.
In this case, check the local drives on the dev server and see if the files of the original Database A are still there (assuming the path of the files on database A is different on the dev box than on the prod). If you succeeded in finding the orphan files, and you can attach them as a different database (eg: A_dev).