|
|
Posted by pluton on 10/01/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
Navigation:
[Reply to this message]
|