Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / vinod

Answers were Sorted based on User's Feedback



SQL stops working in every 15 days displaying message that database log file is full. Log file siz..

Answer / 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

SQL stops working in every 15 days displaying message that database log file is full. Log file siz..

Answer / sujay kumar

You should schedule the job for shrinking the database log.
Sometime, it looks impossible to shrink the Truncated Log
file. Following code always shrinks the Truncated Log File
to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

Is This Answer Correct ?    1 Yes 0 No

SQL stops working in every 15 days displaying message that database log file is full. Log file siz..

Answer / rama krishna

try allocate a room for taht log file

Is This Answer Correct ?    0 Yes 0 No

SQL stops working in every 15 days displaying message that database log file is full. Log file siz..

Answer / rajesh ranjan

In MS SQL Server 2005
select * from sys.database_files
Above Query will return .mdf , .ldf file & all other
details releted to these files of the database
After that you should run following DBCC Statement

DBCC Shrinkfile(Log_file_name.ldf,1,truncateonly)

Is This Answer Correct ?    0 Yes 0 No

SQL stops working in every 15 days displaying message that database log file is full. Log file siz..

Answer / 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

More SQL Server Interview Questions

What does it mean to normalize a database and why would you do it?

0 Answers  

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

Alternative way to DetDate() function?

5 Answers  

What are Row versions of DataRow?

0 Answers  




How do you know if sql server is running on your local system?

0 Answers  

How sql server executes a statement with nested subqueries?

0 Answers  

What is an example of a foreign key?

0 Answers  

What is normalization and denormalization in sql server?

0 Answers  

What does sql server mean?

0 Answers  

What is field with example?

0 Answers  

Explain why variables called the most powerful component of ssis?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories