July 17, 2014 at 11:58 am
HI guys so I am still setting up my home machine. I have installed SQl Server 2008 R2 and all Service packs. I have three .bak files.
After install I right clicked on Databases -> restore database chose the file and it went through just fine. I had some other stuff I had to do and did a restart on my machine. When I went back later to restore the other two .bak files it keeps saying "You must select a restore source" even after I have the file selected. It wont even let me click on options without popping that message. A few hours ago the first one restored in like under 2 minutes.
What am I missing? Very confused...
***SQL born on date Spring 2013:-)
July 17, 2014 at 12:14 pm
I tried the other .bak file to see if it was a fluke about it working. It still works no errors. So I thought maybe the other two were corrupted. re-downloaded and tried again. Same issue, its like it doesn't see the selected file?
***SQL born on date Spring 2013:-)
July 17, 2014 at 12:20 pm
Are all three .bak files valid SQL Server backups? .bak is only the default extension. Backups can be named anything.
Try this:
RESTORE VERIFYONLY
FROM DISK = 'FILENAME'
You should get this message:
"The backup set on file 1 is valid."
Also, are you going BACKWARDS in versions? For example, a backup created using SQL 2012 cannot be restored to SQL 2008. Same as SQL 2008 R2 to SQL 2008,
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 17, 2014 at 12:41 pm
This is what I got.
Msg 3241, Level 16, State 13, Line 1
The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\LeeAnnCPS12.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
The weird thing is it did restore to a 2012 instance. However everything at this shop is done on 2008 r2. So it should be for 2008 r2. I am going to have another Dev try to restore it to his and see if he gets the same thing.
***SQL born on date Spring 2013:-)
July 17, 2014 at 12:48 pm
Double checked it is coming from 2008 r2
***SQL born on date Spring 2013:-)
July 17, 2014 at 1:26 pm
Ran this
RESTORE HEADERONLY FROM DISK='C:\cpsDEMO\democps10sp2.bak'
Back up name was incomplete and the rest of the columns are NULL
***SQL born on date Spring 2013:-)
July 17, 2014 at 1:58 pm
Probably the fastest thing is to take new backups, and restore those.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 17, 2014 at 2:35 pm
I think that's what I'm going to do
***SQL born on date Spring 2013:-)
July 17, 2014 at 4:45 pm
Solution: it was a corrupted file. The first one I used was a ZIP file that I downloaded then had to extract. I downloaded and used the Uncompressed version and it worked fine.
Thanks for your Help!
***SQL born on date Spring 2013:-)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply