What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Course Of The Month
11 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Log file is too large than data file
Posted on 2012-12-26
There is Log file is too large than data file..
What would be the best way to shrink log file in SQL server
The transaction logs are too large, a s I noticed log file size is very large compared to data file & major problem is that the transaction log is continuing to grow
I am looking for a recommended solution to shrink our transaction logs
What would be the best way to shrink log file in SQL server
The transaction logs are too large, a s I noticed log file size is very large compared to data file & major problem is that the transaction log is continuing to grow
I am looking for a recommended solution to shrink our transaction logs
[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
2
4 Comments
If you are in FULL recovery mode; database log will continue to grow unless you backup the transaction log
If you do not need point in time recovery, you may to switch to simple recovery mode
Also Rebuilding the index may cause this. Use SORT_IN_TEMPDB option when rebuilding indexes
Refer the article in case
MSDN Library
If you do not need point in time recovery, you may to switch to simple recovery mode
Also Rebuilding the index may cause this. Use SORT_IN_TEMPDB option when rebuilding indexes
Refer the article in case
MSDN Library
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 8 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.