Home Forums SQL Server 2005 Backups Backup and transaction log RE: Backup and transaction log

  • May 8, 2009 at 4:18 am

    #990967

    sumanta.roy52 (5/8/2009)

    Hi,

    I am taking full backup everyday 23:00 and overwriting it with the existing one. Transaction log every one hour and appending it every hour to get to get all the logs. So transaction log is getting increased. Is it good to delete the whole tranlog after the full backup and creating new one every day?

    What happens if you have only one full backup, you go to restore it and find that it's corrupt?

    Are those older backups going to tape, or just been overwritten.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass