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
- 6950 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
What are subquery and its properties?
What the different components in replication and what is their use?
How to maintain a fill factor in existing indexes?
How to execute a sql statement using mssql_query()?
How to find the service pack installed? : sql server database administration
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is a file group?
Define full outer join in sql server joins?
What is sql azure database?
Explain few examples of RDBMS?
What is the purpose of sql profiler in sql server?
Explain cross join or cartesian product in sql?
What is field with example?
What is updatable resultset?
What are the differences between triggers and stored procedures?
