Posted by pluton on 11/23/67 11:33

Hi,

> transactions were rolled back when you disconnected.

Great! but WHY logi file has 50 MB ? :)
How to shrink it ?

> o You backup the transaction log to disk or tape.
> o You use BACKUP WITH TRUNCATE_ONLY, which cuts the log, but does not
> save it.
> o You have the database in simple recovery mode, in which case SQL Server
> will auto-truncate it.
>
> Notice that truncating is not the same thing as shrinking the file.

Thanks a lot! This is it !

Best regards
pluton

[Back to original message]