Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    12

    Unanswered: Database on FULL model

    I have a question.

    I have a database on Recovery model FULL, i do know that i have to use a Complete Backups and Log backups for it, my question is

    If i made a Complete backup, what happens with the transaction log? same size? i mean need a backup log to clean it ? .

    A complete backup on SQL Server doesn't inclued a log backup?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The log records the changes since the last backup. You can restore your database from just the backup, but the logs allow you to restore modifications made since your last backup.

    Please read Books Online for all the details.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2004
    Posts
    12
    Quote Originally Posted by blindman
    The log records the changes since the last backup. You can restore your database from just the backup, but the logs allow you to restore modifications made since your last backup.

    Please read Books Online for all the details.
    I've read the BOL, let me explain it

    i have a 2 GB database, on FULL model, the transaction log is 800 MB with no automatic grow file.

    I scheduled a complete backup and 2 logs backups during the day, my Transaction log filled because my night log backup failed due the media, i thought that complete backup also backs up log but i found it that doesn't.

    This is how is supposed to work right? if my backup logs fail no matter how many Complete backups i made, my transaction log will fill.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes, database backups do not in themselves truncate your transaction log. The log needs to be dumped with truncate, or it will grow indefinitely.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jul 2004
    Posts
    12
    Quote Originally Posted by blindman
    Yes, database backups do not in themselves truncate your transaction log. The log needs to be dumped with truncate, or it will grow indefinitely.
    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •