This will only affect the log file and not the actual .mdf file? I read
about this command, but Microsoft can be pretty vague sometimes! :-)

-----Original Message-----
From: Mlynar Edward
[mailto:mssqldba-ezmlmshield-x20313040.[Email address protected]
Sent: Thursday, December 28, 2006 8:57 AM
To: LazyDBA Discussion
Subject: RE: Urgent log file full issue

backup log {database name} with truncate_only

ex: backup log tempdb with truncate_only



Ed Mlynar
Database Administrator
Catholic Health East IT Shared Services
Email: [Email address protected]
Phone: 610-567-5377

-----Original Message-----
From: Robert Jenkins
[mailto:mssqldba-ezmlmshield-x28859527.[Email address protected]
Sent: Thursday, December 28, 2006 8:54 AM
To: LazyDBA Discussion
Subject: Urgent log file full issue

Hello everyone, hope all have had a wonderful holiday season so far. I
am in dire need of some guidance. I need to empty the transaction log
without affecting users in a live environment, is this possible?
Please, any advice would be greatly appreciated.



RJ



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page