SQL Server Performance

sqlserver backups

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, May 29, 2007.

  1. priyaram New Member


    we are having both sqlserver 2000 and sqlserver 2005 systems.
    and we are using idera sqlsafe to backup.
    other than restoring the backups,what are the other ways of verifying the backups on regular basis to check whether the backup is good or corrupted.
  2. twoboats New Member

  3. satya Moderator

    RESTORE VERIFYONLY is useful upto some extent as it check to see that the backup set is complete and that all volumes are readable. It does not attempt to verify the structure of the data contained in the backup volumes, hence restore that backup is only best solution.

    If you are able to restore those backups successfully as and when they are backed up, then that is only most reliable way to ensure it is working or not.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. MohammedU New Member

    RESTORE VERIFYONLY improved in sql 2005 compared 2000 but still restore process is the best option as Satya mentioned to make sure it is valid backup.


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page