| Sue Hoegemeier 2006-03-31, 3:23 am |
| A log is truncated when it is backed up. Truncate doesn't
mean reduce the size of the physical file. The option in
sqlmaint to shrink a database is -RmUnusedSpace
threshold_percent free_percent
But it's not really a good idea to setup shrinking on a
regular basis. The size is the usually just the amount of
space SQL Server needs between the log backups.You want to
focus more and appropriately sizing your files. You can find
more info in the following article:
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
-Sue
On 29 Mar 2006 08:48:38 -0800, "zomer" <noneee@gmail.com>
wrote:
>I am using xp_sqlmaint 'switch string here' to obtain log file dumps
>every six hours. The problem is that log continues to grow. DB is on
>full recovery mode. Full DB backup is taken twice a week but log is
>never fully backed up. How do I specify in maintenance plan or in
>switch string to truncate the log when its backed up.
>
>Thank you.
|