Home Forums SQL Server 2008 SQL Server Newbies Modifying a SQL 2000 maintenance plan -- and shrinking RE: Modifying a SQL 2000 maintenance plan -- and shrinking

  • 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!