database error

[bbgirl]

anyone ever seen this attachment, I'm thinking my database is at its capacity...

[bbgirl]

Hello, thanks for the replies, lol. Just kidding, I have another question.

After mustering up the courage, I checked the transaction logs and saw that they were full, so because we have a DB master, i had to bug him and tell him about it. so he just carelessly changed the limit to unlimited.

I dont know much about databases, because I can't stand them, but isn't this a careless action. We have 287 users on this particular BES, with alot of heavy use. So I can only imagine how much data each user consumes, but because our new unlimit limit, I'm afraid the database will become a monster, can someone shed some light on this. I know as one of the BES admins, I need to be more knowledgeable about sql and database, but anyway.


Can someone help out. Isn't there a way to monitor the database logs and space each bb user uses so we can keep our DB under control?

Please help.

[|||||||]

That should be fine, untill the transaction log fills your hard drive.

See KB-03968 for more fun info.

[blablabla13]

Dude...set your DB to simple recovery mode and don't worry much about this in the future.