August 4, 2003 at 7:05 am
HELP !!!
i have a DB with a MS-Access 2k front end, been running fine for the past year, now i am having trouble with the transaction log filling up ! i have it on recovery model 'full'. right now i am just looking for a starting point. code hasnt changed. HELP !!!
August 4, 2003 at 7:11 am
Hi kingram2000,
quote:
i have a DB with a MS-Access 2k front end, been running fine for the past year, now i am having trouble with the transaction log filling up ! i have it on recovery model 'full'. right now i am just looking for a starting point. code hasnt changed. HELP !!!
well, maybe I'm quoting something overstressed, but something must have changed!
Any significant growth in db size recently?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 4, 2003 at 7:42 pm
Hi, Do you have a backup schedule ?
if the data is not critical (but when isn't it?) just do a transaction log backup and delete it , run some optimizations on the database as well. and you will be back to a little transaction log in no time 🙂
------------------------------
Life is far too important to be taken seriously
August 5, 2003 at 6:07 am
everyone ! thanks alot... i was doing the backups and db shrink, and it was working for a while, but since i have this data in a few diffrent places i changed the model recovery model on this DB to simple and now things are ok for now...
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply