Answer / vani

The log files must be backed up, so that the inactive log
records are truncated after every checkpoint thus freeing
up the logspace to be reused.

Schrink your database (Database-All task-Schrink database)
leave 10% free and the size of the log will schrink

Answer / prasadhari_m@yahoo.com

take a backup using this command
backup log dbname with no_log

Answer / lekhrajdeshmukh

We have to decrease the size of a log file by shrinking the
large file.

Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.

dbcc userdb
dbcc shrinkfile(data,7)

Answer / rahul

dbcc shrinkfile ( 'databasename', 'size to be shrinked upto
(in mb)')

What are different types of collation sensitivity?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

What are exact numeric data types in ms sql server?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  

---

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

What is the default fill factor value?

0 Answers  

---

What is the maximum size of sql server database?

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---