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 is a trace frag? Where do we use it?

0 Answers  

---

How we can compare two database data?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

What are the functions in sql server?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How can sql injection be stopped? : sql server security

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---