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 is Schema in Database?

1 Answers   Cap Gemini,

---

What are sql server functions?

0 Answers  

---

Can we use where clause with group by?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,

---

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

How to remove duplicate rows from table?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

Do you know the cursor types?

0 Answers  

---

What is the need for group functions in sql?

0 Answers  

---

How to generate create procedure script on an existing stored procedure?

0 Answers  

---

How to optimize stored procedures in sql server?

0 Answers  

---