| Author |
Topic |
|
moisesfernando
Starting Member
11 Posts |
 Posted - 2004-04-23 : 15:34:37
|
| Hi,I was trying to perform an online backup to a dat tape in a SQL database when I got this error: * I/O error 23(Data error (cyclic redundancy check)) detected during read of BUF pointer = 0x1424f040, page ptr = 0x21792000, pageid = (0x1:0x948fe), dbid = 10, status = 0x801, file = [path][databasename]Can Someone help me ?Thanks,Moisés Fernando |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:14:21
|
| So what do you mean by online backup? Are you backing up the MDF and LDF files directly to tape? If so, you can't do that. If you are performing the backup via the BACKUP command, please post the command.Tara |
 |
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 16:17:53
|
| When I said a "OnLine Backup", I just want to say that the database is being used by applications at this moment. The backup is performed by Enterprise manager.Moises |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:19:15
|
| Is the tape local to the database server? What happens if you back it up to disk first then copy the file to tape?Tara |
|
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 16:23:18
|
| Tara,Yes, it is. We can't do this because we don't have enough disk space.Moisés |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:29:28
|
| If this is SQL Server 2000, do you have service pack 3a installed? Have you been able to backup the database to the DLT before?Tara |
|
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 16:33:36
|
| No, It's a SQL7 database. Yes. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:37:39
|
| Got service pack 4 installed then? Have you tried using a different tape (maybe the tape is bad)? Tara |
|
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 16:37:45
|
| Tara,Do you think this problem can be a hardware failure (a bad block on disk, for example)? Moisés |
|
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 16:40:43
|
| No, the sp installed is sp3. Another tape has been used, but no sucess. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:42:48
|
| Yes it is very possible. I would clean up some disk space immediately, get a full backup, then investigate hardware problems. I would also install service pack 4.Tara |
|
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-04-23 : 17:01:05
|
| Tara,I will try this operations to find a problem. Thanks for support.Moisés |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-23 : 17:35:18
|
| Do you have Backup Exec installed?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
SQL Error