cpetenes wrote:Yeah, not sure why it's so big. It really hasn't been growing much. I know there isn't that much data in it, lol. I hadn't try to shrink it down, but I'm sure it would. Unless maybe it's logs? Hadn't had a space issue so I've left it alone.
Well...It must be log file

.You can decrease the size by setting your DB recovery mode to simple and then shrinking it.
But before that make sure you read
thisI did the same thing for a 260 MB db and the result was almost amazing... Just 11 MB
Edited by user Monday, July 27, 2009 9:00:35 PM(UTC)
| Reason: Not specified