You will have to backup the Transaction Log. You may schedule a job which

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.

Question Posted / nixo

5 Answers
8027 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

Please Help Members By Posting Answers For Below Questions

What do you understand by user-defined function in the sql server?

941

What is difference between delete & truncate commands?

1066

What are the differences between clustered and non-clustered index?

1016

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

Comment,Datatypes are unlimited

2055

What is a partition function in sql server?

1115

Tell me something about security and sql azure?

114

What is the sql profiler?

933

What is dbcc command in sql server?

1079

How to find index size for each index on table?

995

Define self join in sql server joins?

944

How to apply cascading referential integrity in place of triggers?

1025

What is the report builder?

139

What is the web service used for reporting services?

123

What are audit control procedures?

981