thanks
how does backing up a log file free up space? doesn't it simply use up more?
please, I'm new at this
concrete steps
sample SQl
do DIFF backups still work with SIMPLE recovery?
What is did that query show you? What is the recovery model and what was the log reuse wait description? Some of what you do depends on what those tell you. Check those first and let us know what it says.
For the other questions, backing up the log allows space in the file to be reused. That's what they call truncating the log. It's not the same as shrinking the log - so you don't want to confuse the two.
You can take differential backups when you're in simple recovery but they aren't likely to affect the log at all.
Sue
thank you people (I'd say guys but it looks like I am getting advice from wise women here)
we are going with adding more disk space, backing up the log file, shrinking it, then changing it to SIMPLE
I haven't been on the server yet - I don't normally work Tuesday