Backup is Incorrectly Formatted

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Backup is Incorrectly Formatted

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-07-08 : 18:47:30

Hi,

I have following Backup routine.
1. Full Backup at night around 11:30 PM
2. First Differential Backup next day at 12:00 PM
3. Second Differential Backup next day at 6:00 PM
4. Trasactional Logs every 15 Minutes.

SQL Server 2000 Standard edition SP4
Diskspace is enough.

NOW Here is problem.

My Differntial backups producing following error messages every time they execued. They did executed fine at first and ran for 2-3 days but now they are failing with following messages.

"The backup data in 'd:\xyz\Database_Diff_2.BAK' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable."

Here is command which I used to do differential backups (Objective is to overwrite exisitng Daily Diff Backups, so there always be one differential backup)

BACKUP failed to complete the command --MitreCoredata
BACKUP DATABASE MitreCoreData TO DISK = 'd:\xyz\Database_Diff_2.BAK' WITH DIFFERENTIAL,init

Here is how I take full Backup
BACKUP DATABASE @DBName TO DISK = @filename WITH INIT

Is there anything I am doing wrong?
Or Something is going wrong in background.

Please assist me to resolve this issue.

Thanks in advance.

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-08 : 20:15:19

Do you see any disk related error in windows event logs?

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-07-08 : 20:41:30

18210 :
BackupMedium::ReportIoError: write failure on backup device 'd:\xyz\Database_Diff_2.BAK'. Operating system error 112(error not found).

Sorry I didn't look at that, what is that means? we are using VMWARE with SAN, is that some thing related with that?

Thanks in advance

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-09 : 11:15:57

Can you see the folder in windows explorer? Does sql server service account have permission to access it?

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-07-09 : 16:24:59

Yes.. For sure.. First 5 or 6 Backups were taken using same process, then it came up with this error.
I removed both differential backups and let the job executes again, and it went through fine..
Any more ideas?

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-09 : 16:49:20

Check windows event log for os level errors.

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-07-09 : 16:52:00

I already posted Eventlog error above..This is the only error I found.
18210 :
BackupMedium::ReportIoError: write failure on backup device 'd:\xyz\Database_Diff_2.BAK'. Operating system error 112(error not found).

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-10 : 11:08:31

Any error in system event log?

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-07-10 : 16:15:50

No System errors in log file.
Am I using right command to do differential backups? Looking at error means that when it tried to overwritte exissitng diff backup, it failed.. currently it is running fine, but I am sure it will be dead in next couple of days..
I am thinking to delete old Diff backup and then take a fresh one every day, in that case, I am eliminating one possibility.

What are your thoughts?

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-10 : 16:50:54

The command looks ok.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources