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.
Answer Posted / rajkumar
You should schedule the job for shrinking the database log.
or you have to minimize the growth of the log file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to retrieve error messages using mssql_get_last_message()?
What is a natural primary key?
what's the information that can be stored inside a bit column? : Sql server database administration
What is msdb database? : SQL Server Architecture
Can sub report data source be different from that of the parent report?
How to get the definition of a stored procedure back?
What are system databases in ms sql server?
What is the difference between resultset and resultsetmetadata?
How many types of objects are there?
How to integrate the ssrs reports in application?
When is the use of update_statistics command?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are different types of statements that are supported by sql?
Is it possible in sql table to have more than one foreign key?
How to list all schemas in a database?