February 26, 2008 at 10:24 am
Hello All,
Our support team has recently received 3 calls from our customer stating the transaction log for the MODEL database has grown quite large (in excess of 12GB) with no corresponding data growth. As far as we know nothing is using MODEL, there are no user objects and never any connected sessions to the database.
We know how truncate the log and shrink it back down to size. What we don't know is how to determine what would be using the MODEL DB's transaction log.
If any one has any experience with this issue I'd really appreciate any feedback you have.
Thanks in advance.
Norm
February 26, 2008 at 11:18 am
the only way a tx log can grow is through use. At least as far as I know. I would profile the server to verify that there is no use of the model db.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2008 at 9:36 am
Put the model database in simple recovery model. Also don't create any table in the model database and no transaction there.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 9:55 am
Sugesh Kumar (2/27/2008)
Put the model database in simple recovery model. Also don't create any table in the model database and no transaction there.
Just be aware that by doing this any new databases you create on that server will be in Simple mode as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2008 at 10:21 am
Yes model database acts as a template for new databases to be created. so having the model database set to simple has to be done only when needed.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 6, 2013 at 1:36 pm
Is there a way to read the transaction log for the model table. I'd like to see what is going on with it. It is up to 80 GB in a month!!!!
February 7, 2013 at 2:18 am
Do you have any tables in Model Db. Check what all process using the database.
Someone might have accidentally pointed to this db instead of user db.
February 7, 2013 at 7:30 am
Nothing in there but we think we've narrowed it down to happening upon System Table Backup! The log has autogrown by 7 GB in 1 night.
February 8, 2013 at 3:19 pm
Profiler will help you. Look at the Objects and Performance event classes.
----------------------------------------------------
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply