Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8234 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
How to list all login names on the ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How do I completely remove sql server instance?
Why do we use non clustered index?
How to defragment table indexes?
Is it possible to call a stored procedure within a stored procedure?
What is sql server agent and what are the two modes of authentication in sql server?
How to delete a login name in ms sql server?
What is snapshot report?
How to use subqueries with the exists operators in ms sql server?
What are binary string data types in ms sql server?
What is the new security features added in sql server 2016? : sql server security
Explain the concepts and capabilities of sql server?
What is optimistic concurrency?
How can I add Reporting Services reports to my application?
