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 / rama krishna

try allocate a room for taht log file

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between temp table and cte?

726


What Is Rdbms?

843


Explain differentiate between a having clause and a where clause?

689


Do you know what are acid properties of transaction?

695


Explain in brief about Microsoft SQL server?

734


What are different types of raid levels?

748


How to create indexed view?

735


How to loop through result set objects using mssql_fetch_array()?

755


Explain the difference between clustered and non-clustered index?

689


What is the chart in report?

125


What is difference between view and materialized view?

707


how can a database be repaired? : Sql server administration

696


Do you know what is rank function?

809


Tell me what is the order in which the sql query is executed?

708


Explain contrast amongst grouped and non-bunched records?

716