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
- 8073 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 purpose does the model database serve? : Sql server database administration
What are 3 ways to get a count of the number of records in a table?
Explain few examples of stored procedure over triggers?
What is the syntax to execute the sys.dm_db_missing_index_details?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is enhanced database mirroring in sql server 2008?
Explain the properties of a relational table?
What does <> symbol mean?
What is the cpu pressure?
What is the difference between count () and rowcount ()?
Explain the various types of concurrency problem?
optimization techinques
What is the maximum size of a dimension? : sql server analysis services, ssas
What are drillthrough reports?
What is partition in sql server?
