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
- 8072 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
Why use triggers?
What is the purpose of floor function?
What is 2nf in normalization?
How to provide login information for a new odbc dsn?
What is the purpose of the model database?
How to execute a stored procedure in ms sql server?
What are the advantages of using third-party tools?
what are the critical issues you have resloved in your company
Explain few of the new features of sql server 2008 management studio
Explain the difference between delete,drop and truncate in SQL Server?
How do you start single user mode in clustered installations?
Explain query editor regions
How to delete existing rows in a table?
How to access the inserted record of an event?
what method you can use to reduce the overhead of Reporting Services data sources?
