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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy