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: Today @ 10:24 AM
Points: 424, Visits: 1,049
how to truncate the transactional logfile?
Post #762171
Posted Thursday, July 30, 2009 12:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:20 AM
Points: 5,019, Visits: 10,555
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #762193
Posted Thursday, July 30, 2009 1:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 2,242, Visits: 3,647
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: Today @ 10:24 AM
Points: 424, Visits: 1,049
ok, thanks........
Post #762226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse