|
|
Posted by Simon Hayes on 09/28/05 12:40
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]
|