truncate the transactional logfile

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

I think the real question is "Why truncate the log file?".

See this article for more info:

-- Gianluca Sartori

ps. One Orange Chip Points: 29422 More actions · Answer 2

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

charipg SSCrazy Eights Points: 9888 More actions · Answer 3

SSCrazy Eights

Points: 9888

July 30, 2009 at 2:50 am

ok, thanks........