Re: Manually truncate a LOG file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/13/04 

Date: Fri, 12 Nov 2004 20:05:22 -0500

Take a look at the DBCC SHRINKFILE option in BooksOnLine. If you are only
going to truncate the log why not set the recovery mode to SIMPLE? 

-- 
Andrew J. Kelly  SQL MVP
"Don" <anonymous@discussions.microsoft.com> wrote in message 
news:546301c4c908$6a3ab450$a401280a@phx.gbl...
> That's the command I used on my 30GB LOG file and after
> it ran without errors, all the pink turned to blue in EM
> and the space remained the same.
> How can I get rid of all of this space in the LOG file?
>
> Thanks,
> Don
>
>>-----Original Message-----
>>BACKUP LOG database_name
>> WITH  TRUNCATE_ONLY
>>
>>BOL describes it nicely.
>>
>>--------------------------------
>>Mike Epprecht, Microsoft SQL Server MVP
>>Zurich, Switzerland
>>
>>
>>IM: mike@epprecht.net
>>
>>MVP Program: http://www.microsoft.com/mvp
>>
>>Blog: http://www.msmvps.com/epprecht/
>>
>>"Don" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:64e601c4c903$3e4969e0$a301280a@phx.gbl...
>>> SQL 7.0
>>>
>>> How do I manually truncate a LOG file?
>>>
>>> Thanks,
>>> Don
>>>
>>
>>
>>.
>>

Relevant Pages

  • Re: truncate Logs
    ... Why do you want to truncate it? ... http://www.support.microsoft.com/?id=317375 Log File Grows too big ... http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File ... http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: truncate tables in my tablespace
    ... tablename have the same restriction with constraints as truncate? ... DELETE will also have issues with foreign keys. ... SQL> -- Add primary key to emp ...
    (comp.databases.oracle.server)
  • Re: Synonym in trucate table, drop table ...
    ... if I do truncate table tx ... synonym however works for insert, select, delete, update etc. ... since I am not usually the owner when I use the command I have used: ... procedure owned by the target table owner that uses dynamic SQL to ...
    (comp.databases.oracle.server)
  • Re: Synonym in trucate table, drop table ...
    ... if I do truncate table tx ... synonym however works for insert, select, delete, update etc. ... since I am not usually the owner when I use the command I have used: ... procedure owned by the target table owner that uses dynamic SQL to ...
    (comp.databases.oracle.server)
  • Re: Synonym in trucate table, drop table ...
    ... if I do truncate table tx ... synonym however works for insert, select, delete, update etc. ... since I am not usually the owner when I use the command I have used: ... procedure owned by the target table owner that uses dynamic SQL to ...
    (comp.databases.oracle.server)