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.

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

What are a database and a data warehouse?

0 Answers  

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

How to delete duplicate rows from table except one?

0 Answers  

What are the purposes and advantages stored procedure?

0 Answers  

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

What is the datatype of rowid?

0 Answers  

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

what is mean by constraints in sql?

5 Answers   Granada, IBM,

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

What is logon trigger?

0 Answers  

Do you know what is a trace frag? Where do we use it?

0 Answers