sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

Question

sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

karthik babu

Hall of Fame

Points: 3335
More actions
March 17, 2014 at 11:58 pm

#283488

please let me know how this can be solved..
the backup taken in SQL Server 2008 R2 10.50.2500 version is not restoring in SQL Server 2008 R2 10.50.4000
irrespective of the destination server is a bit higher version, the error occurs...
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

Viewing 12 posts - 1 through 11 (of 11 total)

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Are you talking about MSDB?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

karthik babu Hall of Fame Points: 3335 More actions · Answer 2

its not any of the system database.. its one of the user database

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

What is the error message you are getting?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

karthik babu Hall of Fame Points: 3335 More actions · Answer 4

am not able select the backup file.. pls check the attached screeshot.

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

karthik babu Hall of Fame Points: 3335 More actions · Answer 5

here it is..

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

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

Do the restore from T-SQL, post the exact error message.

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

karthik babu Hall of Fame Points: 3335 More actions · Answer 7

Msg 3241, Level 16, State 13, Line 1

The media family on device 'F:\DB backup\backup_2014_03_07_220436_4816312.bak' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

karthik babu Hall of Fame Points: 3335 More actions · Answer 8

Hi all.. sorry for the inconvenience.. the backup file is been corrupted. just find using Restore Headeronly..

thanks!!

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

free_mascot One Orange Chip Points: 27169 More actions · Answer 9

Yes, that was my next step.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

karthik babu Hall of Fame Points: 3335 More actions · Answer 10

I copied the file from other part of the world using TeraCopy.exe. Though the file size in bytes is same, the SQL command says its incomplete. Need to find other way to bring 20 GB of data to my local server.

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

free_mascot One Orange Chip Points: 27169 More actions · Answer 11

use robocopy

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."