Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8229 Views
- I also Faced
- E-Mail Answers
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
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain various On-Delete options in a DB table. Which is the default option?
Give main differences between "Truncate" and "Delete".
What are the properties of the transactions?
What is the downside of using udf?
What is intellisense?
What is meant by datasource?
How to get the definition of a view out of the sql server?
What is the difference between ddl and dml?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is policy based management (pbm)? : sql server database administration
Can you please differentiate between a primary key and a unique key?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Does transparent data encryption provide encryption when transmitting data across the network?
What is transaction server distributed transaction?
