SQL Server Management Studio 2012 Express : how to Restore from a backup
Posted on 2014-07-25
I installed the 2012 SQL Server Management studio express, but when I want to use Tasks / Restore, it functions entirely differently than my 2008 version and I can't get it to do it.
I select: Source / Device:
then I select my backup MyData.Bak file.
Then I set my destination to:
Then I select a timeline:
The last backup taken.
Then I check the Restore box and it requires I Verify Backup Media, which I never had to do before.
Then I can press OK and it fails with the error that:
MyData.mdf can't be overwritten as it is being used by database MyData.
However, I do NOT want it to overwrite MyData.mdf. I want it to create MyData_Dev20.
I never had this problem with 2008.
What can I do to use this thing? It's a mess!!!