Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Montreal
    Posts
    38

    Question Unanswered: Probably easy question on transaction logs

    Hi,

    I have a transaction log that is 1311 Mb in size. I'd like to reduce it. From what I have read, I should just backup the entire database (or simply the transaction log) and it should reset the transaction log.

    Either I can't read, I forget things (it's been a while since I read on that subject) or there's something wrong because a backup didn't empty my transaction log at all. It's still the exact same size!!!

    The only way I found to successfully delete every bit of data in a transaction log was to detach the database, delete the log file and re-attach the database.

    There must be an easier way!?!?!?!

    Thanks,

    Skip.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    DBCC SHRINKFILE
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69
    Are you using SQL 2000?
    If so you can do that by the following

    - Go to DB properties and change the backup type to FULL
    - Take a backup of the database and keep it safe.
    - Go to DB properties again change the backup type to SIMPLE
    - Go to all tasks and Shrink the file
    - Go to DB properties again and change the backup type to FULL again so that it logs everything.

Posting Permissions

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