0

I have been working on a SQL Server database designing since long now and I have observed that when a .bak file is mailed or kept and downloaded from ftp site, it gets corrupted.

When I try to restore, it gives me 3013 error code with messsage:

"Backup or restore operation terminating abnormally.

I tried RESTORE VERIFYONLY FROM DISK='C:\abc.bak' as well but it says

VERIFY DATABASE is terminating abnormally.

Any idea why this is happening and also, is there a better way to move the database file from one server to another (I do not have the access to source server)

Thanks in advance.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Raj Jayaswal
  • 468
  • 1
  • 9
  • 22

2 Answers2

1

For FTP make sure that you use binary mode. Did you try to send plain attachment to yourself and compare the results with the files from sent and received email?

Germann Arlington
  • 3,315
  • 2
  • 17
  • 19
  • Yes I tried downloading the sent file as well and received file as well. but they both are corrupted. Any idea why? – Raj Jayaswal Jul 19 '12 at 11:34
  • If the sent version does not work check that the version that you were trying to attach works. If that does work, check how you attach the file - any weird connection issues, try using webmail and email client to send an email and compare the results. I am startign to suspect that your bak file gets corrupted before it is attached or downloaded, make sure that you can restore new database from the backup immediately. – Germann Arlington Jul 19 '12 at 16:12
  • I did it and the attached version works fine. This are the steps I followed: 1) Backup a db and check if it can be restored: Yes 2) Upload .bak file and save it in draft and check: Yes 3) Send a file to someone and check the sent file: No 4) Check the received file: No – Raj Jayaswal Jul 20 '12 at 03:23
  • OK, if your sent and received versions of the file do not work - which email client are you using? Did you try webmail? – Germann Arlington Jul 25 '12 at 09:50
0

As mentioned here

You may need to repair your mdf file first using some tools. There are lot of tool available in the market. There is tool called Restore MS SQL Database which is very useful to repair the mdf files.

The issue might me because of corrupted transaction logs, you may use tool Restore MS SQL Database to repair your corrupted mdf file.

Vignesh Kumar A
  • 27,863
  • 13
  • 63
  • 115