I’ve never really paid any attention to the properties on the model.mdf database but I just noticed the modellog.ldf file is greater than 26GB (because the recovery model is set to Full and the transaction log isn't being backup). I'm running SQL 2000 with SP3a.
1. If the model.mdf database is a template for new databases to be created from, why is there any transaction activity that would cause the modellog.ldf to grow?
2. Can I set the Recovery Model to Simple instead of Full?
3. If I set it to Simple will this keep it from growing and will it reduce its size or do I need to take some other action?
Thanks.
1. If the model.mdf database is a template for new databases to be created from, why is there any transaction activity that would cause the modellog.ldf to grow?
2. Can I set the Recovery Model to Simple instead of Full?
3. If I set it to Simple will this keep it from growing and will it reduce its size or do I need to take some other action?
Thanks.