Re: TDP Sql question about log growing

2009-01-23 Thread Del Hoobler
. Thanks, Del "ADSM: Dist Stor Manager" wrote on 01/22/2009 10:14:11 PM: > [image removed] > > Re: TDP Sql question about log growing > > Paul Dudley > > to: > > ADSM-L > > 01/22/2009 10:15 PM > > Sen

Re: TDP Sql question about log growing

2009-01-22 Thread Sabar Martin Hasiholan Panggabean
Behalf Of Del Hoobler Sent: Friday, 23 January 2009 1:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP Sql question about log growing 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 re

Re: TDP Sql question about log growing

2009-01-22 Thread Paul Dudley
Sent: Friday, 23 January 2009 1:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP Sql question about log growing 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 siz

Re: TDP Sql question about log growing

2009-01-22 Thread Del Hoobler
"ADSM: Dist Stor Manager" 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" > > Pleas

TDP Sql question about log growing

2009-01-22 Thread Robert Ouzen Ouzen
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 /l