croezen
6th September 2006, 15:27
( SQL2000, WIN2003 )
We are using MSQL-backup to backup our database and then put it on tape with NT-backup.
The file is about 57Gb and when i backup it, in the backuplog i get the following error;

Backup started on 6-9-2006 at 5:22.
WARNING: Portions of "\sql_backup\baandb\baandb_db_200609060400.BAK" cannot be read. The backed up data is corrupt or incomplete.
This file will not restore correctly.

When i do a manual backup of the file instead of the normal backup-job i get the error
"insufficient system resources exists to complete the requested service"

But the file is on the tape! and when i restore it, it puts the file back but gives the error ;
"insufficient privilege fot the file blablabla.BAK - skipped"
"warning; the file blablabla.BAK was restoured from an incomplete or corrupt backup"

But the file is put back in place again!

I don't dear to try an restore the file in SQL. Does anybody has any idea's what's the problem?