Posted by Erland Sommarskog on 07/08/05 22:21

akej (forum@SQLMonster.com) writes:
> What about Database maintenance plan??? is it helpful???
>
> i mean if i configured it to tun everey night, and perform backup is T log
> will shrinked ???

If your database plan includes a backup of the transaction log, it
will trunctate the log. There should not really be any shrink, though.
Shrinking is only something you should do in special cases.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Query error during runtime
• Prev in forum: Re: Oracle Stored Procedures VERSUS SQL Server Stored Procedures
• Thread view: Re: Log file size not reduce

[Reply to this message]