asked on MSSQL Log files taking up 28 GB
Dear Experts,
I was alerted by the users not receiving emails, and when I went into our Exchange server, I realized that C drive was critically full. I started to clean up, after running disk clean up, and doing routine things, I still did not have enough room.
I found out that MSSQL 10_50.SBMONITORING\MSSQL\L
We are using Windows Small BUsiness Server 2011 Standard, and besides Exchange Server 2010, there is a database program on this drive. The data is stored on another drive.
Please advise.
I was alerted by the users not receiving emails, and when I went into our Exchange server, I realized that C drive was critically full. I started to clean up, after running disk clean up, and doing routine things, I still did not have enough room.
I found out that MSSQL 10_50.SBMONITORING\MSSQL\L
We are using Windows Small BUsiness Server 2011 Standard, and besides Exchange Server 2010, there is a database program on this drive. The data is stored on another drive.
Please advise.
Microsoft SQL Server
Last Comment
yballan
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
First lesson:
- Do NOT install user databases in C: drive. It will affect your operating system.
Second lesson:
- When using databases with Full Recovery model you need to schedule regular transaction log backups to truncate the file.
- Do NOT install user databases in C: drive. It will affect your operating system.
Second lesson:
- When using databases with Full Recovery model you need to schedule regular transaction log backups to truncate the file.
ASKER
Thank you, Experts, for pointing me tot he right direction!!
Good luck!