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
- 6956 Views
- I also Faced
- E-Mail Answers
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 is the difference between dropping a database and taking a database offline?
How do you start single user mode in clustered installations?
what is raid and what are different types of raid configurations? : Sql server database administration
What's new in sql management studio for sql server? : sql server management studio
What are the five characteristics of good data?
Explain what is row_number function?
What are the main sources of data?
How can you list all the table constraints in a database?
Explain various On-Delete options in a DB table. Which is the default option?
what data regions are and what are the different data regions?
What happens if you delete a table that is used by a view?
What are partitioned views?
Difference between Logical Page and Physical Page in SSRS.
What is the stuff and how does it differ from the replace function?
How do I completely remove sql server instance?
