How do I get the logfile to truncate? I have tried everything (except obviously the right thing).
Actually, everything short of writing a query to do it, which I have not attempted since every gui way seems to fail so my faith in writing the query is low.
I do daily FULL backups, I only have one database, one instance and the stupid logfile is 14gig and has run out of space causing all jobs to fail.
What stupid thing am I not doing? I seem to remember that SQL6 full backups also truncated the log??
I even did a backup of the transaction log selecting the options to have the transactions that have already been written be removed.
PLEASE set me straight. I have month end reports due and can't load my data.
Thanks!
Actually, everything short of writing a query to do it, which I have not attempted since every gui way seems to fail so my faith in writing the query is low.
I do daily FULL backups, I only have one database, one instance and the stupid logfile is 14gig and has run out of space causing all jobs to fail.
What stupid thing am I not doing? I seem to remember that SQL6 full backups also truncated the log??
I even did a backup of the transaction log selecting the options to have the transactions that have already been written be removed.
PLEASE set me straight. I have month end reports due and can't load my data.
Thanks!