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
What is Sqlpaging in SqlServer 2005 ?
What do you understand by SQL*Net?
query processing
What are the basic functions for master, msdb, model, tempdb databases?
What are the five characteristics of good data?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What are the differences between stored procedure and the dynamic sql?
What is report snapshot in ssrs?
what is the sql equivaent of the dataset relation object ?
Can sql servers linked to other servers like oracle?
What are the types of user defined functions in sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is rank function?
What is for xml in sql server?
What is bcnf normalization form?