Sql-server – SQL Server 2000 Backup fails with Status = 33

backupsql serversql-server-2000

I am trying to take a Full Backup of a database size about 75GB.

It is SQL Server 2000 - 8.00.2055 x86 version. I have plenty of disk space where the backup is being created. So disk space isn't an issue.

The backup process starts fine but half way through it errors out just saying with status = 33.

enter image description here

I have been looking for any information online but couldn't find anything…. Any suggestions any solutions any pointers in the direct direction is much appreciated…….

Best Answer

Further investigation and "Googling" solved the issue, The issue was with drive, It was compressed and SQL Server did not like that.

Solution

Removed the compression from Drive and this time backup completed without any errors and much faster.