Restore database issue

Question

Restore database issue

newbieuser

SSCrazy Eights

Points: 9423
More actions
December 2, 2013 at 4:05 pm

#395926

Hi friends,
I'm trying to import customer's SQL 2005 database(database.bak) onto our SQL Server 2012 server. I right clicked on database in the Management studio 2012 , restore database using source - device option. Selected database.bak file for the restore. But it is not recognizing the backup file, I keep getting 'No backupset selected to be restored'. It doesn't show up under the restore plan either.... Not sure what I'm missing..
Please help. Thanks a lot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Aram Koukia SSCommitted Points: 1521 More actions · Answer 1

newbieuser (12/2/2013)
Hi friends,
I'm trying to import customer's SQL 2005 database(database.bak) onto our SQL Server 2012 server. I right clicked on database in the Management studio 2012 , restore database using source - device option. Selected database.bak file for the restore. But it is not recognizing the backup file, I keep getting 'No backupset selected to be restored'. It doesn't show up under the restore plan either.... Not sure what I'm missing..
Please help. Thanks a lot.

Usually if you use the TSQL for restoring it will help you better since it gives you more details about the actual error

give this a try and let me know what happened:

RESTORE DATABASE <YourDatabase>

FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

[font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]

newbieuser SSCrazy Eights Points: 9423 More actions · Answer 2

Thanks... I get this

Msg 3241, Level 16, State 1, Line 1

The media family on device 'C:\Backup\db1_bkup.bak' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Damaged backup. Get a fresh backup from the 2005 server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 4

Are you sure the backup completed successfully? If you file copied the backup file to the SQL2012 server did the copy complete successfully? If you have the file on the SQl2005 and 2012 servers compare the size of them...

also you can run this command against the backup file:

restore verifyonly from disk = 'E:\YourDBName_db_201211061216.bak'

I would agree... the backup file is not good.