Re: controlling log size
From: Jason (jafinck_at_pplweb.com)
Date: 09/16/03
- Next message: Sue Hoegemeier: "Re: interface tools for MSDE"
- Previous message: Artur: "Re: how to give developer right to run SQL profiler without assign them SA right"
- In reply to: Sue Hoegemeier: "Re: controlling log size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 16 Sep 2003 10:17:48 -0700
Thanks Sue
>-----Original Message-----
>You don't want to set something up to delete your
>transaction logs but probably want to come up with a solid
>backup plan that keeps the transaction log at a manageable
>size and allows for a recovery plan that meets the
business
>needs.
>When you backup a transaction log, you mark parts of the
>log as inactive which means you can write data to those
>parts of the log. The inactive part of the log can be
reused
>for writing new transactions. Backing up a transaction log
>doesn't change the size, it just means you have those
>inactive parts of the log to use for recording
transactions
>and then the log won't continue to grow as parts of it
will
>be able to be reused.
>If you need to reduce the physical size of the log, you
can
>do this using dbcc shrinkfile. But you really want to
focus
>on the backups and not let the log go, the shrink it, let
it
>go then shrink it, etc as it's not a good use of your
server
>resources to keep doing the file shrinking. Managing the
>size through appropriate backusp would be better.
>Also, if you don't use the transaction logs as part of
your
>recovery plan, you could look at the simple recovery
model.
>For more information refer to books online - there are
>several topics on transaction logs and recovery models
which
>can do a better job of explaining this in more detail.
>
>-Sue
>
>
>On Mon, 15 Sep 2003 11:23:29 -0700, "Jason"
><jafinck@pplweb.com> wrote:
>
>>Hi,
>>
>>I have a question on controlling log size. I see that
by
>>default the log will fill up the whole disk.
>>
>>How can I make it use say 1 gig of space and then after
it
>>hits 1 gig delete the old data as it needs room for now
>>log data?
>>
>>Can this be done in MSDE too?
>>
>>thanks
>>-Jason
>
>.
>
- Next message: Sue Hoegemeier: "Re: interface tools for MSDE"
- Previous message: Artur: "Re: how to give developer right to run SQL profiler without assign them SA right"
- In reply to: Sue Hoegemeier: "Re: controlling log size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
