Disk space / log file size problem

Question

Disk space / log file size problem

Viewing 4 posts - 16 through 18 (of 18 total)

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

christinelucey Valued Member Points: 63 More actions · Answer 1

Thank you again, Stacenic. You ROCK! I'm looking this up right now in books online.

christinelucey Valued Member Points: 63 More actions · Answer 2

According to books online, "NO_LOG and TRUNCATE_ONLY are synonyms." Yet the NO_LOG command worked when I tried it, but TRUNCATE_ONLY, which is the first thing I tried, did not.

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 3

You were running the TRUNCATEONLY in the shrinkfile. Did you try the backup log with truncateonly?

Shamless self promotion - read my blog http://sirsql.net

christinelucey Valued Member Points: 63 More actions · Answer 4

Yes, I was. I see my mistake now. Was confusing TRUNCATEONLY with TRUNCATE_ONLY. Thank you again.