You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
Course Of The Month
2 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SCCM Database Log file
Posted on 2010-09-08
I am having an issue with my SCCM SMS_SITE_log.ldf file.
The current SMS_SITE_mdf file is 2.3 gig and the SMS_SITE_log.ldf file is 75 gig.
How do I reduce the SMS_SITE_log.ldf file size?
The current SMS_SITE_mdf file is 2.3 gig and the SMS_SITE_log.ldf file is 75 gig.
How do I reduce the SMS_SITE_log.ldf file size?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
2- +1
12 Comments
A majority of log file sizes like this have to be changed by the registry. This link should get you in the right track.
http://support.microsoft.com/kb/275742
http://support.microsoft.com/kb/275742
What that does is allow you to limit the file size on your log file. So what you could do is specify the max size that you want for that particular log file. So for your 70gb log file, lets say you want it down to 2 GB max. You could change the max file size to 2 GB and it will delete all old records up to the point where the file size is 2 GB. Make sense? It definitely does work as I have had to use this method in my site.
Sorry dude I think I mis understood completely. Your going to need to set the max file size on that in your SQL server.
What you will want to do is log onto your SQL server. Double click on Databases. Right click your SMS_(three digit site code) and click properties. Then click on files, and change the autogrowth settings for SMS_SITE_LOG. You can set your max file size in there. If you have any questions, please let me know. Sorry again for the confusion.
Here is a link with a description on how to automate clearing those files.
http://www.redolivedesign.com/utah-web-designers-blog/2008/08/22/automated-fix-for-sql-ldf-file-growing-out-of-control/
http://www.redolivedesign.com/utah-web-designers-blog/2008/08/22/automated-fix-for-sql-ldf-file-growing-out-of-control/
HI
If a database uses full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
to Backup your log use the KB below
http://msdn.microsoft.com/en-us/library/ms179478.aspx
if your batabase configured with simple recovery, you dont have the option to backup the log file and only full backup.
I recommend to full backup your database then shrik the log file
I have attached images to how to make full backup , then how to shrink your DB log size.
Good Luck!
Tarek Ismail
00.png
1.png
2.png
3.png
5.png
6.png
7.png
8.png
9.png
If a database uses full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
to Backup your log use the KB below
http://msdn.microsoft.com/en-us/library/ms179478.aspx
if your batabase configured with simple recovery, you dont have the option to backup the log file and only full backup.
I recommend to full backup your database then shrik the log file
I have attached images to how to make full backup , then how to shrink your DB log size.
Good Luck!
Tarek Ismail
00.png
1.png
2.png
3.png
5.png
6.png
7.png
8.png
9.png
The Database Recovery Model is set to FULL, does that change how I need to reduce the log file? Do I need to change it to simple?
As your Database Recovery Model is set to FULL , you always need to backup the log with option to truncate the log file after backup, as in my attached images.
you can switch from full to simple according to your backup stratigies you will use, in simple backup you can restore only the database from last full backup , but if you make it full recovery you can backup the database and the log then you have the option to restore to specific point of time from your log files.
from my side , i like full recovery to be configured for database.
Note: SMS2003/SCCM2007 defualt installtion use SIMPLE Database Recovery Model
after you backup the log file , you can shrink the Database log file , also you can configure the autogrouth.
I hope you find my reply answers all your questions!
Good Luck
Tarek Ismail
1.png
2.png
3.png
you can switch from full to simple according to your backup stratigies you will use, in simple backup you can restore only the database from last full backup , but if you make it full recovery you can backup the database and the log then you have the option to restore to specific point of time from your log files.
from my side , i like full recovery to be configured for database.
Note: SMS2003/SCCM2007 defualt installtion use SIMPLE Database Recovery Model
after you backup the log file , you can shrink the Database log file , also you can configure the autogrouth.
I hope you find my reply answers all your questions!
Good Luck
Tarek Ismail
1.png
2.png
3.png
Featured Post
This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack. My needle was an anti-virus version causing problems with my Exchange server.
I have an HP DL350 with Windows Server 2008 Stand…
Have you considered what group policies are backwards and forwards compatible?
Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month2 days, 9 hours left to enroll
718 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.