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
How adventureworkslt tables are related?
What is buffer cash and log cache in sql server?
What is standby servers? Explain types of standby servers.
What are the steps you can take to avoid “deadlocks”?
In case you have filters in your report, when filters will be applied in cached report instance?
What is an indexing technique?
Can group by and orderby be used together?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is inline variable assignment?
How to use the inserted and deleted pseudo tables?
What is difference between join and natural join?
How can we determine what objects a user-defined function depends upon?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What do I need to start working with sql studio? : sql server management studio