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
- 7902 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
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the datatype of rowid?
1 01 101 01010
Tell me what is use of except clause? How it differs from not in clause?
What are the different authentication modes in sql server?
Explain ms sql server reporting services vs crystal reports?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How do you delete a data source?
please differentiate between delete and truncate?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the difference between createstatement and preparedstatement?
Describe in brief authentication modes in sql server.
How do you improve the performance of a SQL Azure Database?
Explain the difference between primary keys and foreign keys?
can a table be moved to different filegroup? : Sql server administration
