SQL Server Performance

Verify the integrity on the backup completion

Discussion in 'General DBA Questions' started by NewDBA, Feb 23, 2004.

  1. NewDBA New Member

    We backup database ,restore it to different server and then check the integrity to avoid overhead .
    However "Verify the integrity on the backup completion" option is on.
    Isn't that meen that we actually check integrity on production and then additionally on development?
  2. Luis Martin Moderator

    Not neccesary, may be in one server is on and another is off. You can change options anytime.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  3. NewDBA New Member

    I guess I didn't ask question clearly.


    On production server option "Verify the integrity on the backup completion"
    is turned on.

    Is that meen that we actually checking integrity of the database everytime we backup?
  4. Luis Martin Moderator

    I gess yes.

    This is from BOL:

    Verify the integrity of the backup on completion of the backup

    Check that the backup set is complete and all volumes are accessible by executing the RESTORE VERIFYONLY Transact-SQL statement.



    Luis Martin
    Moderator
    SQL-Server-Performance.com
  5. NewDBA New Member

    Let's me put it this way:

    Is

    Integrity check for Data maintanence Plan

    and

    Verify the integrity on the backup compleation doing the same thing?

  6. NewDBA New Member

    look what i found:that meen that verify and integrity are different thinds

    Although not required, verifying a backup checks that the backup is intact physically, and that you can rely on your backup in the event you need to use it. Verifying a backup involves:

    Checking the backup set to ensure that all files have been written.


    Checking to ensure that the files in the backup are readable.
    Verifying a backup does not check that the structure of the data contained within the backup set is correct. For example, although the backup set may have been written correctly, it may be possible for some type of database integrity problem to be present within the database files that comprise the backup set. To verify the structure of the data before creating a backup, you can perform database consistency checks. For more information about running database consistency checks, see
  7. Luis Martin Moderator

    Sorry New, I missunderstand your original question.
    Integrity check for Data Maintanance Plan is different than Verify backup.
    What you found about Verify is Ok.

    This is what I find about Integrity Check:

    Check database integrity

    Check the allocation and structural integrity of user and system tables, and indexes in the database, by running the DBCC CHECKDB Transact-SQL statement. This ensures that any integrity problems with the database are reported, thereby allowing them to be addressed later by a system administrator or database owner.



    Luis Martin
    Moderator
    SQL-Server-Performance.com
  8. satya Moderator

    In my experience on the production system do not enable the option "Verify the integrity on the backup completion" because resource of time taken will be bit high if the system is 24/7 OLTP application.

    As you've got information about those 2 options, nothing to comment.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page