what the error means

xdai · June 18, 2009 12:30PM

I am trying to restore a backup file stored on remote server, after add the file, i got read filelist error, sql error 3013, and sql error 3241, the media family on device is incorrectly formed , sql server cant process this media family. So what does that means? and how to fix that. Thanks

xdai · June 18, 2009 12:39PM

more info: the backup copy is created on the sql server 2005 box, and we put it on a sql server 2000 (sp4) box to tell the server (where sql 2005 on) to restore it.

Eddie D · June 18, 2009 1:28PM

Thank you for your post into the forum.

I suspect that the backup file you are using for the restore has become corrupt.

If I have understood your actions correctly, you performed a backup using SQL Backup on a Server A (SQL 2005). You then copied the backup file from Server A to another location, Server B (SQL 2000 machine). Next you attempted a restore of the backup file located on Server B.

I have known the above process to corrupt a backup file, particularly if the file was copied using Windows Explorer.

You can check to see if the copied backup has corrupted using a hash generator and create a checksum for each backup file. If the checksum hash generated is not identical, the backup file used in the restore is most likely corrupt.

You can download a checksum MD5 hash generator using this LINK

If you wish to copy the SQL Backup file from location A to location B and restore using the file at location B. I recommend that you either:

A. Use the COPYTO argument within the backup job to copy the file to location B.
or
B. Make use of our Copy Tool which can be download from our ftp site using this LINK
or
C. Use an alternative copy application such as 'XCopy' or 'RoboCopy'.

Many Thanks
Eddie

xdai · June 18, 2009 1:44PM

Hi Eddie,

Server A couldn't remain that many copies, so we copy the backup each day using Avamar to another location, yesterday i try to retrieve the backup which dated two weeks ago, so the analyst retreive that copy from avamar server and put in server B, (they are located in the same location), so this morning i try to restore the backup to server A and spcecify the file location on server B, got error. So you suspect the copy from Avamar to server B corrupted the file? Is that perform a checksum to find out? thanks

petey · June 22, 2009 10:36PM

Are you trying to restore a SQL Server 2005 database on a SQL Server 2000 server instance? That cannot be done.

what the error means

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk