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
- 6282 Views
- I also Faced
- E-Mail Answers
Answer Posted / sujay kumar
You should schedule the job for shrinking the database log.
Sometime, it looks impossible to shrink the Truncated Log
file. Following code always shrinks the Truncated Log File
to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please explain what is “asynchronous” communication in sql server service broker?
What is cross join in sql server joins?
What is the purpose of self join?
Can you pass expressions to function parameters?
What are the differences between web role and worker role?
What are the aggregate and scalar functions?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What are different types of replication in sql server?
What will be the maximum number of indexes per table?
Where can you add custom error messages to sql server?
What is field with example?
What is the difference between varchar and varchar(max) datatypes?
Explain the phases a transaction has to undergo?
What do you understand by integration services in sql server?
What is a subquery in a select query statement in ms sql server?
