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


Please Help Members By Posting Answers For Below Questions

How to replace null values in expressions using isnull()?

836


What do you think of this implementation? Can this be implemented better?

695


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

292


What are extended events in sql server?

661


What is self contained multi valued query?

735






What are scalar functions in sql?

804


How to create an inline table-valued function?

705


What is the difference between migration and upgradation in sql server?

780


What is the difference between count and distinct count?

615


What are key, name and value columns of an attribute? : sql server analysis services, ssas

757


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

706


What are the types of subscriptions in SQL Server replication?

723


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2178


Which are the new data types introduced in sql server 2008?

661


How do I trace a query in sql server?

694