Robert,
You need to run a LOG backup in order to truncate the logs.
BTW, truncating the transaction log does not reduce the size of a
physical log file; it reduces only the size of the logical log file.
To reduce the size of a physical log file, it is necessary to shrink the
file,
using, for example, the DBCC SHRINKFILE command.
Here is an IBM Technote that discusses it:
http://www-01.ibm.com/support/docview.wss?uid=swg21199294
If you want real deep details, look here:
http://msdn.microsoft.com/en-us/library/ms190440.aspx
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 01/22/2009
03:31:10 AM:
> TDP Sql question about log growing
>
> Robert Ouzen Ouzen
>
> to:
>
> ADSM-L
>
> 01/22/2009 03:32 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Hi to all
> In a sever Windows 2003 with SQL database I saw that a log increase
> very much ( to +26 GB) , it was programmed with the option Recovery
> Model: Full
>
> I run every day a full backup (not any log backup) with the command:
>
> tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%
> sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log
>
> I add those lines in my dsm.opt:
>
> INCLUDE "\...\meta\...\*" mgwhighlearnf
> INCLUDE "\...\data\...\*" mgwhighlearnf
>
> If I understand correctly the full backup truncate the log after it
> finish ??? In my case running just full backup I can turn it to just
> Recovery Model: simple
>
> But just for knowledge why the full backup did not clear the log ?????
> I first turn the Recovery Model to: simple to run a shrinking
> procedure (turn the log to 10MB).
>
> By the way what the difference if instead of the lines of the
> INCLUDE I wrote previous I will write:
>
> INCLUDE "\...\meta\...\full*" mgwhighlearnf
> INCLUDE "\...\data\...\full*" mgwhighlearnf
> And let my recovery model to: Full
>
> Did now it will truncate the log after each full backup ??????? or I
> need to add a truncate option somewhere ????
>
> My TDP for SQL version is 5.2.1.0
>
> Regards,
>
> Robert Ouzen
