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)')

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What are the new features in sql server 2016?

0 Answers  

---

What are functions

3 Answers  

---

What is a natural primary key?

0 Answers  

---

What is the openxml statement in sql server?

0 Answers  

---

---

How m-m relationships are implemented?

2 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

What is the use of DBCC commands?

4 Answers   NA,

---

How many full-text indexes can a table have?

0 Answers  

---

What is difference between drop truncate and delete?

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---