im go to take adhoc sql full backup, before application upgrade
BACKUP DATABASE testdb
TO DISK = 'C:\testdb.BAK'
WITH STATS, DESCRIPTION = 'Full backup for AdventureWorks'
how do you I know, my backup is not corrupted, and will work after restore, incase if required
Sorry I dont have environment to test.. it..
Do i need to do consistency check or readability check before take backup, if yes, how can i do that in Tsql?