I got an email from the web host today that my db is over the size limit.
They said it was 7000 MB.
I knew i didn't have that much data, so I went to look at the database.
The only info they give me is that the data file is 900 MB and the log file is 6000 MB.
I don't know enough about the inner workings of SQL Server to mess with it, but it sounds like the problem is the log file.
What can i do to clean it up and make the database smaller?
Thanks.




Reply With Quote