December 11, 2014 at 9:05 am
I know this is easy but I am having trouble creating a database from a backup file.
I created a database (Test).
Then I selected 'Test', went to Tasks and selected 'Restore Database'.
I selected 'Device' browsed to the backup file.
I choose the destination database to be 'Test'.
There is no backup sets listed to restore. The 'OK' button is disabled.
How do you get the backup list to display? This is a new database. I don't need a backup.
Where am I going wrong?
December 11, 2014 at 9:08 am
What happens if you do [font="Courier New"]RESTORE HEADERONLY FROM DISK = 'MyFile'[/font], where MyFile is the path to and name of your backup file?
John
December 11, 2014 at 9:12 am
I have not tried that. But I will.
Why use 'HEADERONLY' keyword? Will this restore include all of the data?
December 11, 2014 at 9:14 am
No, it will only show what backup set(s) are on the backup device (file). Have a read of the RESTORE topic in Books Online.
John
December 11, 2014 at 9:17 am
The result of the RESTORE HEADER ONLY command is that the backup name is listed as '***INCOMPLETE***'.
Looking at the file size, it is not the same as the original.
I will copy again.
Thanks for your help for such a basic issue!
Gloria
December 11, 2014 at 9:19 am
Never seen that before. But if I had to guess, I'd say that the backup that was made to that file was interrupted and didn't finish.
John
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply