Answer / sagi.rahul

Restore is what we do with backups. Take the backup file and
turn it back into a database.

Recovery is something that SQL does every time it brings a
database online. It goes through the transaction log and
ensures that the database is consistent

Answer / rajesh

Restore means we have a backup files(.bak) and that backup
files can provide all the previous information about the
restored data, Like tables, stored procedure.


Recovery means we have lost(Like tables, stored procedure)
the data but we want to recover that data or information, so
at that time we can perform some actions and that actions is
called recovery.

Answer / chandra mouli paidi

Restore is a uploading files back into database

Recovery is missing file finding and reloding in database

How do I find the port number for sql server?

0 Answers  

---

Why transaction is important?

0 Answers  

---

What is dirty page?

0 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

What are the dis_advantages of stored procedures, triggers, indexes?

0 Answers  

---