Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

truncate the transactional logfile Expand / Collapse
Author
Message
Posted Thursday, July 30, 2009 12:13 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 2:24 AM
Points: 437, Visits: 1,088
how to truncate the transactional logfile?
Post #762171
Posted Thursday, July 30, 2009 12:59 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 4,655, Visits: 11,122
I think the real question is "Why truncate the log file?".

See this article for more info:

http://www.sqlservercentral.com/articles/64582/


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #762193
Posted Thursday, July 30, 2009 1:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
charipg (7/30/2009)
how to truncate the transactional logfile?

Gianluca has a valid question.

You may want to search for Backup Log with Truncate_only/DBCC SHRINKFILE in BOL. But you should understand the consequences first.





Pradeep Singh
Post #762213
Posted Thursday, July 30, 2009 2:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 2:24 AM
Points: 437, Visits: 1,088
ok, thanks........
Post #762226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse