Date: 03/31/05 (SQL Server)    Keywords: no keywords

Hey all. I have a quick question I was wondering if anyone had any experience with. Does anyone know if a successful completion of a 'restore filelistonly' command would indicate that a backup file is valid? I've noticed some of our backup jobs failing during the verify phase of the maintenenace plan because of network issues, and I'd like a quick way to check if the backup is valid because some of the backup files take hours to verify.

Source: http://www.livejournal.com/community/sqlserver/23255.html