Check consistency and allocation errors before backup

• Roberto Cota Soares

  SSC Rookie

  Points: 31

  More actions

  February 24, 2006 at 9:27 am

  #111683

  Hi,

  My maintenance plain is:

  • recovery full
  • complete backup at 12:10
  • log backup every hour

  I ran dbcc checkdb and repair_allow_data_loss was the minimum repair level for the errors found.

  So I decide do restore the backup. I restored the backup and I ran dbcc again: repair_allow_data_loss was the minimum repair level for the errors found.

  I tried to restore only the full backup (I didn't restore the logs), and DBCC gave the same msg.

  How be sure that my database have no erros before make the backup? Is this necessary? What can I do?

  Thanks (and sorry my bad English),

  Roberto Cota

   

• Vichka

  Ten Centuries

  Points: 1218

  More actions

  March 2, 2006 at 1:59 pm

  #624468

  Hi,

  I have in our maintenance plan :

  Check integrity first and it says "perform these tests before making backup", so I am thinking this plan is checking everything first.

  You can do that form EM Database Maintenance Plan , create the new one with checking db before the backup.