Professional Web Applications Themes

transaction logs-too large? - Microsoft SQL / MS SQL Server

Hi, My transaction logs are unbelievably getting large, even larger than the databases. Is there any kind of routine SQL can do to trim it down? Thanks Lee...

  1. #1

    Default transaction logs-too large?

    Hi,

    My transaction logs are unbelievably getting large, even
    larger than the databases. Is there any kind of routine
    SQL can do to trim it down?

    Thanks
    Lee

    Lee Guest

  2. #2

    Default Re: transaction logs-too large?

    INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
    http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
    "Lee" <org> schrieb im Newsbeitrag
    news:053101c36b3a$b168daa0$gbl...


    Jens Guest

  3. #3

    Default Re: transaction logs-too large?

    Lee,

    You may need to control the transaction log growth.There is no automatic
    shrinking inbuilt unless you specify.If you care about log backups, then
    schedule a sql job which will take log backups at regular intervals.If you
    dont care, then check the option "truncate log on checkpoint" on database
    properties(sql7), "simple" recovery model(sql2000) and BACKUP LOG
    <databasename> WITH TRUNCATE_ONLY .These actions would only truncate ( or
    empty ) the log so that no further space is extracted unless needed.In order
    to shrink (or reduce the physical size of the file ), refer:

    --SQL7
    INF: How to Shrink the SQL Server 7.0 Transaction Log
    http://support.microsoft.com/support/kb/Articles/q256/6/50.asp
    and/or
    www.sqlserverfaq.com and search for "sql7shrinklognowork.txt"


    --SQL2000
    INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
    http://support.microsoft.com/support/kb/Articles/q272/3/18.asp


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Lee" <org> wrote in message
    news:053101c36b3a$b168daa0$gbl... 


    Dinesh.T.K Guest

Similar Threads

  1. Replies: 5
    Last Post: February 16th, 09:04 AM
  2. Replies: 0
    Last Post: February 2nd, 02:44 PM
  3. Transaction logs...
    By Paul in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 21st, 02:33 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139