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 / nixo
You will have to backup the Transaction Log. You may
schedule a job which backs up the log every night.
Backup the log before shrinking the database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What area unit the various kinds of info compression introduced in sql server 2008?
What is stored in the mssqlsystemresource database? : sql server database administration
How to create nested stored procedure?
What is check constraint in sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How do I find the default sql server instance?
What is the tcp/ip port on which sql server runs?
What is clustered primary key?
Define inner join in sql server joins?
What is checkpoint process in the sql server?
What are the diifferences between the ms sql server vs mysql?
What is a database in ms sql server?
Difference between Sql server reporting services and Crystal reports?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is the difference between index seek vs. Index scan?