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.
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
Explain cross join or cartesian product in sql?
What is the difference between stored procedure and functions?
What is the Difference Between Primary and Foreign Key?
How will you find out if there are expensive SQL statements running or not?
What part does database design plays a role in performance of an sql server-based application?
How to rename databases in ms sql server?
How do I manually uninstall an instance of sql server 2016?
Explain rdbms?
What is cdc in sql server?
what are the Prerequisites for Replication?
Does sql server 2000 clustering support load balancing?
Explain unique key in sql server?
What is entity data services?
What are the different index configurations a table can have?
What is bcp? When does it used?