sql server 2005 - Verifying Full database backups "WITH CHECKSUM" -


We have a daily maintenance plan in SQL Server 2005 that is full on disk using "back up database task" Backups.

"Confirm Backup Integrity" is enabled, but the data aggregation which is understandable is valid only if there is a checksum in the backup media, which was enabled by the "without checksum" option during backup is. From the generated T-SQL, I can see that the maintenance plan is not working like this, apart from hacking code commands manually, how do we specify in this work (if it is actually possible)? After further investigation it appears that the data concentration through drag-drop attributes is called " It is not possible to configure work to verify "with checksum" alone, this command should be added to the T-SQL function of SQL Server Management Studio


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -