SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent.
- 5 Answers
- 6958 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajkumar
You should schedule the job for shrinking the database log.
or you have to minimize the growth of the log file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between mongodb vs. Sql server?
How do you create type- insensitive operator?
Explain differences between web edition and business edition?
What are difference between Cluster index and Non-Cluster index?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Explain different types of index?
What is trigger in salesforce?
Can coalesce return null?
Why I am getting this error when renaming a database in ms sql server?
what stored procedure would you use to view lock information? : Sql server administration
How to add code to the existing article (using improve article)?
How to create a new table in a given schema?
Tell me what is fill factor?
Explain the relational database management system (rdbms)?
How to insert multiple rows with one insert statement in ms sql server?
