Sql Server 2000, backup Issue

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  September 24, 2008 at 11:28 pm

  #71098

  Hi all,

  I set the full recovery model in database and i configured full backup every day at 10:00 PM, now db size 185 GB so whenever working of backup sehuedule it is taking backup time hardly 6 Hrs, daily DB Growth is 1 GB.

  Please tell me anybody, how to reduce the total backup time? if i configure other recovery model

  Thanks

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  September 25, 2008 at 12:27 am

  #876794

  I do not think you can decrease the backup time by changing the recovery model.

  You can increase the backup time by using third party backup tools like SQL Litesppend, Red Gate etc..

  In sql server 2008 there is option with ENCRYPTION which reduces the backup time.

  Rajesh Kasturi

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  December 5, 2011 at 6:51 am

  #1416658

  do a full backup on a weekend, differentials every day except your full backup day, tx logs every X mins/hours

  E.G

  Sat, Sun, Mon, Tue, Wed, Thurs, Fri

  Full, Diff, Diff, Diff, Diff, Diff, Diff

  That way your only backing up the changes, not the full DB every night