Professional Web Applications Themes

Huge Log Files - Microsoft SQL / MS SQL Server

Will,  [/ref][/ref] 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 and BACKUP LOG <databasename> WITH TRUNCATE_ONLY .These actions would only truncate ( or empty ) the log.In order to shrink (or reduce the physical size of the file ), refer: 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" -- Dinesh. ...

  1. #1

    Default Re: Huge Log Files

    Will,
     [/ref][/ref]

    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 and BACKUP LOG <databasename> WITH TRUNCATE_ONLY .These actions
    would only truncate ( or empty ) the log.In order to shrink (or reduce the
    physical size of the file ), refer:

    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"

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

    "Will T" <com> wrote in message
    news:phx.gbl... 
    Is 
    there 


    Dinesh.T.K Guest

  2. #2

    Default Re: Huge Log Files

    Will, you might want to look up DBCC SHRINKFILE.
    HTH
    A Joshi

    "Will T" <com> wrote in message
    news:phx.gbl... 
    Is 
    there 


    Ajoshi Guest

  3. #3

    Default Re: Huge Log Files

    I have tried Shrink Database from within Enterprise Manager and it has
    little affect, but I will look at SHRINKFILE.

    -Will

    "Ajoshi" <org> wrote in message
    news:phx.gbl... [/ref]
    control. 
    > there 
    >
    >[/ref]


    Will Guest

  4. #4

    Default Re: Huge Log Files

    You need to read the KB articles to get the full story:


    INF: How to Shrink the SQL Server 7.0 Transaction Log
    http://support.microsoft.com/default.aspx?scid=kb;en-us;256650

    INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
    http://support.microsoft.com/default.aspx?scid=kb;en-us;272318

    http://www.mssqlserver.com/faq/logs-shrinklog.asp


    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Will T" <com> wrote in message news:phx.gbl... [/ref]
    > control. 
    > > there 
    > >
    > >[/ref]
    >
    >[/ref]


    Tibor Guest

Similar Threads

  1. Compare huge XML Files
    By John Bokma in forum PERL Modules
    Replies: 7
    Last Post: February 26th, 02:59 AM
  2. File upload. Huge files
    By Oleg Slyusarchuk in forum ASP.NET Building Controls
    Replies: 1
    Last Post: August 4th, 09:54 PM
  3. Why are Illustrator CS files so huge?
    By angelia@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 8
    Last Post: April 9th, 12:16 PM
  4. Upload *huge* files, is it wise with PHP ?
    By Stephane in forum PHP Development
    Replies: 5
    Last Post: December 18th, 11:25 AM

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