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
- 7844 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 kind of lan types do you know? : Sql server database administration
How to add code to the existing article (using improve article)?
How to defragment table indexes?
Name few endpoints exposed by ssrs 2012?
Write a sql query to delete duplicate records from a table called table1
What is the New in SQL server 2008?
Explain about integration services of Microsoft SQL server?
What is the default value of an integer data type in sql server 2005?
What is db stored procedure?
How can change procedure in sql server?
What is b tree index?
What are differences in between sql server 2012 and sql server 2016?
Describe in brief system database.
Tell me what is log shipping?
What is table constraint?
