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

Define left outer join?

571


How can windows applications connect to sql servers via odbc?

573


What are the purposes and advantages stored procedure?

492


Differentiate between ms sql server reporting services vs crystal reports?

479


Explain the Ways to improve the performance of a sql azure database?

64






Where are stored procedures in sql server?

556


What are the 2 types of classifications of constraints in the sql server?

577


What are the differences between union, intersect, and minus operators?

564


What is difference between standardization and normalization?

519


What the class forname () does?

532


What does it mean if @@cursor_row returns a negative number?

567


Some queries related to SQL

580


What languages bi uses to achieve the goal?

502


How important do you consider cursors or while loops for a transactional database?

522


List some of the rules that apply to creating and using a ‘view’

488