Answer / Ashish Bhatia

In a worst-case scenario, if a failure occurs between the last full backup (which happens every night) and the next one (after 24 hours), you could potentially lose all data created or modified within those 24 hours. This is because differential backups only capture changes made since the last full backup, and incremental backups capture changes since the latest backup (either full or differential).

how do u find least salary in a table

4 Answers  

---

Can an automatic recovery be initiated by a user?

1 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

What are the types of containers in ssis?

1 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

How to concatenate two character strings together?

1 Answers  

---

What is a Join in SQL Server?

3 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1 Answers  

---

What is attribute hierarchy? : sql server analysis services, ssas

1 Answers  

---