Answer / ravi kanth

In 10g i think using flashback command we can get back.

Answer / adhi

IN MS SQL SERVER 2005.

1.Take Tail Log backup
2.Restore Full backup
3.Restore Diff (If u have)or Log backup in sequence order
4.Restore Tail Log backup

Answer / ravi

In this case data only deleted but table structure is there.
so can flashback the the data.
example:-

delete * from emp;

ans:- insert into emp select * from emp as of timestamp
sysdate -3/1440;

Answer / anil panwar

tell me which command used for delete..

Explain log shipping?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

Define candidate key, alternate key, and composite key.

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

How data can be copied from one table to another table?

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---