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 ms sql server index?

0 Answers  

---

what does the automatic recovery do? : Sql server administration

0 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

Explain what are the authentication modes in sql server?

0 Answers  

---

---

Does a server store data?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Can primary key be null?

0 Answers  

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

What is the difference between set and select?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---