|
|
Posted by Danny on 09/28/05 14:51
Just to be clear. Setting the recovery model to 'Simple' will truncate
inactive portions of the log (free space within the file) automatically.
But you will still need shrink the log file at least once to reclaim the
disk space.
"Simon Hayes" <sql@hayes.ch> wrote in message
news:1127900426.992461.284090@g43g2000cwa.googlegroups.com...
>I don't really understand your first question, but the log is there to
> ensure that all changes to the database can be rolled back/forward if
> necessary, such as when the server crashes. See "Transaction Logs" in
> Books Online. As for shrinking it, see here:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql2k
>
> If you don't need transaction log backups (see "Selecting a Recovery
> Model" in BOL), then the simplest option may be to set your database to
> the simple recovery model - the log will then be truncated
> automatically.
>
> Simon
>
Navigation:
[Reply to this message]
|