When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

How can you list all the columns in a database?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

What is thr feature of change data capture?

0 Answers  

---