Question
Strange CF/SQL Behavior
Yesterday I started getting "login failed" error messages when CF attempts to run a query against my SQL Server database. The site was basically useless since everything runs off a query. What follows is an email to a fellow employee looking for some help.
IIS, SQL2005, all Windows environment. Same configuration has been working for years.
Soon after we had everything running again, I started getting the "Login Failed" error message all over again. I took a look at the log files and was seeing that the login would be successful, and then, in the same nanosecond, would fail. So there would be two entries for every attempt.
Looking at the SQL database, I saw that it had grown to almost exactly 1 GB. I went to use the "shrink database" command, but it was grayed out. I took the DB offline, and a few minutes later I was able to shrink it. Still no luck with accessing it though.
I went to my tracking tables within the database, and deleted a few years of records. I also emptied out a couple of test tables that I had created. That brought the database down to around 650 mb. Everything has been running fine since then.
Can you think of any mystery surrounding a cutoff point of 1 GB?
AdChoices