Ms SQL Full DB backup error

[Former Member]

Hi all,

We are running ECC6 on Windows 2003 server with Ms Sql 2005, we are trying to take a full db backup on our BW DEV system, but we get the following error....

Due to this we are not able complete the BW Process tarnsfers... which is very important.....

We use DB13 for this activity.

The error mesage reads as follows

<b><i>Executed as user: NT AUTHORITY\SYSTEM. DBCC execution completed. If DBCC printed error messages, con

tact your system administrator. [SQLSTATE 01000] (Message 2528) Write on "R3DUMP0(
.\tape0)" failed: 23(Data error (cyclic redundancy check).) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed</i></b>

I request all the gurus to kindly help me as i am very new to all this...

So i request you to suggest me the best possible solution asap.

Waiting to hear from you all...

ThanKs a million in advance.

Hari Haran.V

[Former Member]

This message was moderated.

[Former Member]

HI all, i request you all to chk my new posting on the same problem...

[vincentlim826]

This error doesn't look so good. The OS return the error code 23 : Data error (cyclic redundancy check)

Normally error code 23 was due to hardware fault. Please consult your

hardware vendor/provider on this problem.

Vincent

[Former Member]

Hi vincent,

Sorry for posting twice, but the fact is that i missed out a point that the same is not case with BW prd server for which it is the same backup device we are using,

Also FYI both our BWDEV and BWPRD are in a single physical server, but running on different HDDs....

Now what is the next solution that i can suggest my client....

I m working on this from OFFSHORE....

so there depends a lot on the suggestion i give them...and i just dont want to misguide or suggest them with my HALF knowledge...

So can you plz focus a lil more into the explainaton u sent me, please.

Waiting to hear from you,

and I thank you for your quick and helpful responce.

Thanks again

Regards

Hari haran

[vincentlim826]

I'm saying that this CRC (cyclic redundancy check) error was due to hardware /disk faulty. CRC is similar like checksum or some sort of verification process to read the bit pattern from the disk. So, I can see that it has been corrupted somehow, and the disk reading is not ok.

at this moment I would suggest you run DBCC CHECKDB and fix any allocation errors / table inconsistency, and hopefully that help (not guaranteed).

cheers,

Vincent