Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Accidentally i deleted my table. How can i get that table?

Question Posted / adhi

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

What does the on update no action do?

962

What is data compression?

941

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

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

1044

What are the differences between lost updates and uncommitted dependencies?

1011

what is spatial nonclustered index

943

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

814

What is a database in ms sql server?

991

Working with TLogs

1783

What is the stuff and how does it differ from the replace function?

1003

How can you tell if a database object is invalid?

1013

What is a result set object returned by mssql_query()?

1070

How to call a function from a stored procedure in SQL Server ?

952

what is isolation level at dead lock?

2088

What are various ways to enhance the ssrs report?

920