clare.xia (2/7/2011)
I can stop SQL server and rename the log file for MSDB and let it generate a new one and then delete the old log file.
There's a very good chance it won't generate a new one (database not cleanly shut down), and you'll be left with a system database in recovery_pending. Not fun.
Got a recent backup of MSDB?
Is the drive full? If so, do you have another drive with space?
Are you sure about the kB/MB measurements? It catches a lot of people.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability