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
