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.

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

What is the importance of concurrency control?

0 Answers  

How can I tell if sql server is 32 or 64 bit?

0 Answers  

How to execute function in stored procedure sql server?

0 Answers  

Define self join?

0 Answers  

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

What information is maintained within the msdb database?

0 Answers  

Can you tell me about the concept of ER diagrams?

0 Answers  

What is row_number () and partition by in sql server?

0 Answers  

What are Row versions of DataRow?

0 Answers  

How to find the source of a table in sql server?

0 Answers  

What are the recovery models for a database?

0 Answers