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.

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

Answer / rama krishna

try allocate a room for taht log file

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)

Answer / rajkumar

You should schedule the job for shrinking the database log.
or you have to minimize the growth of the log file.

What is forward - only cursors / read only cursor?

0 Answers  

What are data files?

0 Answers  

Explain subquery and state its properties?

0 Answers  

Explain few of the new features of sql server 2008 management studio

0 Answers  

What is a view?

6 Answers  

What are the types of user defined functions in sql server?

0 Answers  

What is row by row processing ?

2 Answers  

How can sql server instances be hidden?

0 Answers  

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

0 Answers   Abacus,

What is sql server profiler trace data file?

0 Answers  

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

Explain about thread and memory management process of SQL?

0 Answers