Backup Error - SQL Server Forums

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 Error

Author

Topic

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 16:29:21

Hi all i am getting this error while i am running backup job in EM

BlkHeader from strip 0 At 38a68400 ExpectedAt 38a68400 Size f000 PrevSize 1c00

How can i solve it and why did this happen??

thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-18 : 16:49:45

Not sure what that errors mean. Try running backup command in Query Analyzer. If you get the same error, run DBCC CHECKDB in QA to see if the database is corrupt.

Tara

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 16:58:18

i ran that and got this

CHECKDB found 0 allocation errors and 0 consistency errors in database 'op_apps_daily'.
DBCC execution completed.
no errors so what would it be wrong?

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-18 : 17:00:33

Not sure. Try running backup from QA:

BACKUP DATABASE DBName
TO DISK = 'E:\MSSQL\BACKUP\DBName.BAK'
WITH INIT

Change what you need to in the command. WITH INIT means overwrite the file if it exists.

Tara

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:07:54

hi getting this stuff

Processed 247304 pages for database 'op_apps_daily', file 'ab_op_appsData' on file 1.
Server: Msg 3241, Level 16, State 40, Line 1
The media family on device 'G:\Dailyfullbackups\opapps.BAK' is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-18 : 17:09:43

Does that file exist on disk? If it does, delete it first then run the command. This would be on the database server itself, not on the machine you are running the command from UNLESS it is from the database server. Also make sure that directory exists.

Otherwise, make sure you have sufficient disk space on the G drive for this backup.

Tara

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:10:13

and got this error in log file:

BlkHeader from strip 0 At 38a68400 ExpectedAt 38a68400 Size f000 PrevSize 1c00

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:11:11

yeah there is no file exist and there is 400g space so space is no matter>>> but got the error saying: BlkHeader from strip 0 At 38a68400 ExpectedAt 38a68400 Size f000 PrevSize 1c00

don't know why!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-18 : 17:11:54

I would also run DBCC CHECKDB against the system databases to make sure those are fine too.

Tara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-18 : 17:13:20

Are you running service pack 3a plus the latest security patch for SQL Server? If not, try those and see what you get. Otherwise, try the MS knowledge base and search for you error:

http://support.microsoft.com

Tara

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:13:59

means run against master, msdb, and model?

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:14:25

means run against master, msdb, and model?

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-18 : 17:15:07

i have service pack 3 right now!!!

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-18 : 18:43:49

Pat, I think that's a hardware error, not a SQL Server error. Look in your System event log and see if you see any errors in there.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-19 : 12:28:12

but what this error means:

BlkHeader from strip 0 At 38a68400 ExpectedAt 38a68400 Size f000 PrevSize 1c00

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-19 : 12:35:57

It is referencing your hard disks.

Tara

PatDeV
Posting Yak Master

197 Posts

Posted - 2004-08-19 : 16:37:20

but only log backup is failing but regular backup is running fine!! Why that!!