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
- 7915 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
How do I run a trace in sql server?
Explain stored procedure?
What are the rendering extensions of ssrs?
What do you understand by recursive stored procedures?
Can we add a cpu to sql server?
What are the types of sql server?
Is there any difference between primary key and unique with the not null condition?
explain how to create a new schema in a database? : Sql server database administration
Give the query of getting last two records from the table in SQL SERVER?
Can we install sql server 2016 on windows 7?
Explain an incremental backup?
Explain what are the different index configurations a table can have?
what kind of lan types do you know? : Sql server database administration
Explain what is dbcc?
What is the meaning of resultset type_scroll_insensitive?
