RE: Trimming SQL log files (*.LDF Files) - SQL v8

2008-04-09 Thread Louis, Joe
pril 09, 2008 1:59 PM To: NT System Admin Issues Subject: RE: Trimming SQL log files (*.LDF Files) - SQL v8 Have a good backup before you do that. You lose the ability to restore transactions since the last backup. Actually, the backup job should be shrinking the log files for you. Are you s

RE: Trimming SQL log files (*.LDF Files) - SQL v8

2008-04-09 Thread Michael B. Smith
: Malcolm Reitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 1:59 PM To: NT System Admin Issues Subject: RE: Trimming SQL log files (*.LDF Files) - SQL v8 Have a good backup before you do that. You lose the ability to restore transactions since the last backup. Actually, the backup

RE: Trimming SQL log files (*.LDF Files) - SQL v8

2008-04-09 Thread Malcolm Reitz
: Wednesday, 09 April, 2008 12:26 To: NT System Admin Issues Subject: RE: Trimming SQL log files (*.LDF Files) - SQL v8 Backup log with TRUNCATE_ONLY See BOL (SQL Books OnLine) Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Mark A. Ross [mailto

RE: Trimming SQL log files (*.LDF Files) - SQL v8

2008-04-09 Thread Michael B. Smith
Backup log with TRUNCATE_ONLY See BOL (SQL Books OnLine) Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Mark A. Ross [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 1:10 PM To: NT System Admin Issues Subject: Trimming SQL log files (*.