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 secure is sql server database?
What is the tcp/ip port on which sql server runs?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is acid db?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
what are constraints? Explain different types of constraints? : Sql server database administration
How do I know if localdb is running?
How to change the system date and time from SQL Plus Terminal ?
What you can do to delete a table without the delete trigger firing?
What to check if a User database is locked?
What is meant by Active-Passive and Active-Active clustering setup?
Explain different types of locks in sql server.
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can we delete data from a view?