|
|
Posted by Erland Sommarskog on 11/12/79 11:33
pluton (zielonadupa@poczta.onet.pl) writes:
> Hi,
>
>> transactions were rolled back when you disconnected.
>
> Great! but WHY logi file has 50 MB ? :)
As I said, the log does not shrink automatically. So if you had a
transaction that required 50 MB in the log, the log grew to 50 MB.
Further review the recovery mode for the database. (Use sp_helpdb for
that.) I explained my previous post when data are removed from the
transaction log.
> How to shrink it ?
That, too, I have told you in a previous post. But there is little point
in shrinking a 50 MB log file. Most likely it will grow to that size
again, unless your database is extremely tiny.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|