Viewing 8 posts - 1 through 8 (of 8 total)
Yes, I was. I see my mistake now. Was confusing TRUNCATEONLY with TRUNCATE_ONLY. Thank you again.
April 15, 2004 at 2:12 pm
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.
April 15, 2004 at 1:54 pm
Thank you again, Stacenic. You ROCK! I'm looking this up right now in books online.
April 15, 2004 at 11:56 am
Stacenic, thank you, that did it!!
I ran that string exactly as you suggested, then ran my dbcc shrinkfile command and set a target...
April 15, 2004 at 11:44 am
Stacenic, where will that put the backup that is created?
April 15, 2004 at 11:03 am
Vikramnat, thank you very much for the detailed explanation. When you put it that way, it does not look so bad at all!
Perhaps I'll give that a try today, on the...
April 15, 2004 at 10:26 am
Not sure if I'm ready to try that. (Yep, I'm a newbie -- and a cautious one at that.)
April 15, 2004 at 9:27 am
Some progress. As Vikramnat suggested, I backed up to another server (by UNC name) that had enough space. That was a great success.
I ran a DBCC Shrinkfile command, aiming to get...
April 15, 2004 at 8:00 am
Viewing 8 posts - 1 through 8 (of 8 total)