Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    74

    Question Unanswered: Reducing the size of the transaction log file

    At this time I am only playing with the applications that generate the data and send it to the database. Without doing too much, and with deleting most data tables that were created, my transaction log file has grown over a gigabyte. I tried using the SQL server management studio (express) to shrink the database (tried shrinking files, too) but that did not make the file smaller. Right now there is hardly any data in the database (6 tables, a dozen columns and rows each) so it must be old transactions that are kept in the log. How do I get rid of the old data and make the file size smaller? Thanks.
    Kamen

  2. #2
    Join Date
    Oct 2006
    Posts
    3
    Hi,

    I had the same issue yesterday, i had to, Backup the log file then use shrink, backup one moore time and shrink.

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    1. Check your database 'Recovery Model', set it according to your requirement.
    2. Make a backup plan matching your data sensitivity & requirement as well as schedule it.
    3. Plan Log backup along with Log Truncate option.

    Refer Books OnLine from SQL Query Analyzer.
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

  4. #4
    Join Date
    Dec 2005
    Posts
    74

    Thumbs up

    Thank you very much!
    Kamen

Posting Permissions

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