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
- 7835 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
How to encrypt data between dialogs?
What are transactions in sql?
Explain “@@rowcount” and “@@error” in sql server?
How network traffic be reduced by using the stored procedure?
Explain left outer join and right outer join?
What are the different types of indexes?
How to use go command in "sqlcmd"?
Is port 1433 secure?
Explain the cursor lock types?
Name few endpoints exposed by ssrs 2012?
What is normalization? What number of normalization shapes are there?
How to get a list of all tables with "sys.tables" view in ms sql server?
If we delete pack Spec what will be the status of pack Body ?
List the different types of joins?
What is the difference between clustered and a non-clustered index?
