5

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.

2 Answers 2

5

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
3
  • 1
    +1 T-SQL is 1000 times better than the GUI. IMHO. Jul 24, 2012 at 18:18
  • Yes! T-SQL Worked fine - I guess I'm submitting it as a bug to Microsoft.
    – Dina
    Jul 24, 2012 at 19:47
  • Worked flawlessly - many thanks, have some upvotes.
    – Alec
    Dec 4, 2012 at 11:31
5

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.

1
  • thanks, selecting the "device" a second time properly refreshed the files page Jan 16, 2017 at 21:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.