I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode.
The page verification is set to TORN_PAGES detection. So, far the backup has been corrupted when we try to copy the backup to an external and restore on a different server.
The error I got in the past was as follows: System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "MMS.mdf" as read from the backup set. (Microsoft.SqlServer.Smo)
If I perform a backup with CHECKSUM enabled in the backup options, then does it look like the restore will work on the other server or is the database itself corrupt?