how to check db bakup is corrupted or not without restoring the .bak file in ssms
I am having the back up of my production server scmdb.bak. before restoring the database back up in sql server management
studio.is there any way to check my database bakup condition either corrupted or in good condition.
Our very own @Grant Fritchey explains the process well in the first video on this page:
http://www.red-gate.com/products/dba/sql-backup/version-7/ - the video entitled "Verify your backups". In short, the only way to truly verify that your backup is in good condition is to restore it. This is one of the things a DR environment can be used for - continually making sure that your backups restore correctly.