Hi,

thanks for your suggestions!

I was in the same boat and it came back working when I set the 64 bit option to "False",

thanks,

S

To be more exact:

backup log DATABASE_NAME with truncate_only

dbcc shrinkfile ([DATABASE_LOG_NAME],2)

where "2" is the desireded size of the log file after shrinking.

Please keep in mind, however, that (quoting SQLBill at

Hi,

try to run

backup log log_logical_name with truncate_only

before running the shrink command.

It normally works for me,

regards,

SG