A maintenance plan that includes a backup and verify cannot complete within the maintenance window. How do you backup and verify the file?
Verify process may take an extended time, depending on the size of the database and individual environment.
The xp_restore_verifyonly reads every block of data to SQL Server so it may take as long as 75% the time that an actual restore take (it's virtually the same process without the writing of the data). It is generally recommend that the backup be completed and moved to a non-production server and the verfiy done there. If the database is corrupt, then the verify may report success, but the file cannot be restored. The verify only is a good test of a backup file, but the best test is a restore.
