I generally have to restore databases to different servers after important data imports or other important and delicate database operations.
I need to be sure that my backups up to that point in time or transaction mark are reliable.
backup set is present and header fields of pages
Are volumes readable?
checksum (if enabled ,
BACKUPby default does not use
destination drive – space check.
I use a lot the following query:
--query by Jack Vamvas - any suspect database? SELECT DB_NAME(database_id),[file_id],page_id, CASE event_type WHEN 1 THEN '823 or 824 or Torn Page' WHEN 2 THEN 'Bad Checksum' WHEN 3 THEN 'Torn Page' WHEN 4 THEN 'Restored' WHEN 5 THEN 'Repaired (DBCC)' WHEN 7 THEN 'Deallocated (DBCC)' END, error_count, last_update_date FROM msdb..suspect_pages
Other than restore verify only with checksum, is there any other way to check if my backups are reliable?