Behaviour of naming file names when using restore wizard in SQL 2012

Question

Ok I am trying to restore a database into SQL 2012 using the wizard.

In 2008 you...

"Right Click Databases folder | Restore Database | Choose your "To database" | Choose your "From Database" (make sure the names are different) | go to options | look at the "Restore As" name and see that the file names match the name of the "To database"

If you do the same thing in 2012 the file names do not change when you change the "Destination database" it simply stays the same as the "Source" database. You can change them manually but this is a pain if you have several files.

So is there an option to change this so that when you change the name of the "destination database" that it will automatically change the names of the files as well?

Thanks

Answer 1

Hello,

I found the following thread on Microsoft Connect:

https://connect.microsoft.com/SQLServer/feedback/details/668566#details

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hey, thanks for the quick reply. I did see that, but that person said it should be fixed in 2012.

Are they meaning that they changed this behaviour to act like it does now on purpose, because I am only having more problems with failed restores in the new version.

Also if this is what Microsoft intended, is there a way to get back to the 2008 way of file naming?

Thank you

Answer 3

Hello,

Based on that thread it seems to be this behavior is by design. To my knowledge, there is no way to make it work like it was working on SQL Server 2008, but you can try to open a Microsoft Connect item and provide your feedback.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 4

Hi mwalkuski,

Thanks for your feedback. For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

Additionally, I suggest using RESTORE Transact-SQL command to achieve the requirement for now.

RESTORE (Transact-SQL):
http://msdn.microsoft.com/en-us/library/ms186858.aspx

---

Allen Li
TechNet Community Support

Answer 5

Ok, thanks for the information and help guys