I have a backup of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak file. Now I want to fiddle with some data so I need to restore it to a different database – Database2.
I have seen this question: Restore SQL Server database in same pc with different name and the recommended step is to rename the original db, but I am out of that option as I am in the production server and I cant really do it.
Is there any other way of restoring it to Database2, or atleast, how do I browse through the data of that .bak file?
thanks.
ps: the second answer from the above link looked promising but it keeps terminating with error:
Restore Filelist is terminating abnormally