Post reply

Transaction log full bacup or clear up space message

  • May 21, 2004 at 2:45 am

    #152154

    Hi all, I've got a message on SQL Server 2k today stating that the transaction log is full. What's the best way to go about backing it up? bearing in mind that the database is currently live - Help !!

  • May 21, 2004 at 8:36 am

    #507297

    First, have you ever done a full backup?

    If not, that's the very first thing you need to do. And do it right now.

    Then backup the transaction log.

    It's very easy to do, you can find the syntax in the Books OnLine (BOL). The BOL is installed as part of the Client Tools and can be found at Start>Programs>Microsoft SQL Server>Books OnLine. Use the Index tab and enter BACKUP DATABASE. The other command you will need is BACKUP LOG.

    Both can be done while the database is operational.

    -SQLBill

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

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