Modifying a SQL 2000 maintenance plan -- and shrinking

• sqladmin 45377

  Valued Member

  Points: 60

  More actions

  November 9, 2012 at 6:33 pm

  #1557865

  GilaMonster (11/9/2012)

  ---

  You should have two separate plans, one that does full backups and runs however often is required for full backups and a second plan that does log backups and runs however often is required for log backups, usually a lot more frequently than full backups.

  The integrity check (DBCC CheckDB) should be run before the full backup preferably.

  Thanks, I'll do that. When I tried to Uncheck "Perform these tests before backing up the db or translog" it refused to take for some reason. It would display as checked when I went back in.

  In any case I'll split the original plan into a daily (evening) Complete Backup plan and an hourly (during business hrs) Trans Log Backup plan so I can have more control over each.

  Thanks again!