Post reply

How to properly backup transaction logs.

  • 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 2 posts - 1 through 3 (of 3 total)

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