Accidentally i deleted my table. How can i get that table?
- 4 Answers
- 8065 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How can you check the level of fragmentation on a table?
What is a primary index?
What is nolock?
What is parameterized reports in ssrs ?
What is sql server locking?
Is it possible to update the views? If yes, how, if not, why?
What are the dmvs?
What triggers long term care?
Explain filtered indexes benefits?
Explain the steps to use transact-sql cursor?
How to create new table with "create table" statements?
What is primary key and example?
What is the parse query button used for?
Explain the different types of backups available in sql server? : sql server database administration
