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
- 6320 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 will happen if a column containing char type data is changed to the nchar data type?
What is an execution plan? How would you view the execution plan?
How does using a separate hard drive for several database objects improves performance right away?
What are date and time data types in ms sql server?
Explain logical operators in sql server?
Define synonym?
Write SQL queries on Self Join and Inner Join.
Give an example of SQL injection attack ?
Explain “@@rowcount” and “@@error” in sql server?
What are the properties of the transaction?
What is msdb database? : SQL Server Architecture
Where is trigger in sql server?
What is a performance monitor?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is table level trigger?
