08-19-2008 10:45 AM
Solved! Go to Solution.
08-19-2008 01:05 PM
08-19-2008 03:22 PM
08-19-2008 04:30 PM
its not supose to be. as is aid you see any transaction logs warnings in app logs? somthing like transaction log size too big or you can try www.blackberry.com/btsc/KB03968
08-19-2008 05:03 PM
08-19-2008 10:01 PM
What is the recovery model for your BESMgmt database?
Set it to simple, perform a full backup of the db, and do some shrinking.
Then set database management tasks to do maintenance / optimizations weekly
08-20-2008 09:21 AM - edited 08-20-2008 09:23 AM
08-20-2008 02:35 PM
08-21-2008 01:26 PM
Right now it is set to full. Will shrinking the database during working hours cause any issues? Sorry, I've always waited after business hours to do things like this incase there's any down time, since we really can't afford it.Message Edited by brooksb on 08-20-2008 09:23 AM
Change it to simple; no need for it to be at full. After changing it, back it up and shrink it. You can do this while the database is in use ... the server will just take a performance it, but BES / other databases will continue to work.
If you want, wait until off-hours, but at no point do any databases come offline during the operation.
08-21-2008 01:29 PM
I did a full backup of the DB and transaction log but Shrinking the database does nothing, it does not keep the size I have set. Should I delete the current ldf file now that I have a backup of it, will it create a new .ldf file?
Did you change the model to simple? Don't delete the LDF. bad bad bad.