Post reply

How to properly backup transaction logs.

  • January 6, 2004 at 9:52 am

    #107570

    Recently had a situation where the disk drive containing the transaction logs failed...but the disk with the actual mdb was intact.

    We did a restore back to earlier in the day to get back up.

    1) Wondering if I could have backed up the data some way in this condition to save it(with trans log missing/gone/damaged).

    2) Need to have some script/way/procecure to properly automatically backup the transaction logs so they can be restored.  YES, I'm a sql newbie.

    I have sql server agent currently setup to backup with truncate the trans logs daily at 12:00.  Hoping to use something similar to backup the trans logs on the hour to use in case of recovery needed.

  • January 6, 2004 at 10:05 am

    #488821

    In the BOL, use the Index tab and enter BACKUP DATABASE. That will not only give information about backing up the database but also about backing up the log.

    Basically, you will run

    BACKUP LOG dbname TO

    You can also search SQL Server Central for more information on backing up and truncating the transaction log. There's alot of information about that already posted.

    -SQLBill

    BOL = Books OnLine = MS SQL Server Help

    Installed as part of the Client Tools

    Found at Start>Programs>Microsoft SQL Server>Books OnLine

  • January 7, 2004 at 12:03 am

    #488892

    Simple way is used the database maintenance plan to configure the full backup and transaction log backup. Remember to change the recovery model to full for transaction log backup in database option.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply