Accidentally i deleted my table. How can i get that table?
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
How to achieve Paging of records in SQL SERVER?
Do you know what are various aggregate functions that are available?
What is scrollable cursor?
What is difference between count (*) and count 1?
What are the different types of sql server replication? : sql server replication
What is report snapshot?
How to execute stored procedure and set temp table in sql server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Explain can you implement data mining in ssrs?
What is sql server database?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are a database and a data warehouse?
What are secondary xml indexes?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are sql dirty pages?