Relocate all files to folder checkbox unavailable sql server 2012

Question

Using SQL 2012 Enterprise edition

Following instructions here for restoring a backup: http://msdn.microsoft.com/en-us/library/ms186390.aspx#Restrictions

I need to be able to rename the database because it is the second copy on the instance (testing purposes). But I cannot rename it nor change the folders that it will restore the MDF/LDF files to.

For whatever reason the "Relocate all files to folder" checkbox is not available.

Restoring form a SQL 2005 backup.

Answer 1

Try to do this with T-SQL:

restore database YourDatabase_NewName
from disk = 'C:\YourDir\YourDatabase.bak'
with
 move 'YourDataFileName' to 'C:\DataDir\DataFile.mdf',
 move 'YourLogFileName' to 'C:\LogDir\LogFile.ldf'
go

• Dina: Yes! T-SQL Worked fine - I guess I'm submitting it as a bug to Microsoft.
• Alec: Worked flawlessly - many thanks, have some upvotes.

Answer 2

When you select the "Device" (file) to restore your database from, the Database combobox below is populated and the first item is selected.

But! Whatever event that populates the Files grid is not firing. If you explicitly select your database from that drop down, the Files grid will then populate and the "Relocate all files to folder" checkbox will enable.

• Dave Cousineau: thanks, selecting the "device" a second time properly refreshed the files page