I have a SLQ server with one database on it and the transacion log is growing. Is there any way to get this file down in size without changing the recovery model? Its set to full right now. Ive also read conflicting stories on shrinking the log file.
I need some expert advice as Im running out of room :(