SQL Server - Is it possible to recover a dropped table?
Asked By Ravi Kumar
03-Jun-04 01:11 PM
Hi All,
Accidentally I have dropped a table and that is the main table for my application.
I dont have a backup of it. Is there any way to recover it.Please help me guys.
Thanks,
Kumar.
Are you sure you don't have a backup
When a database is created in SQL Server, it is set to Full Back Up by default. So, your table should be available by restoring the transaction backup. Try going to the "restore database" options by right clicking on the database name in Enterprise Manager and selecting All Tasks.
You know, I dropped a table
on my foot once, and I don't think I ever recovered. Lots of luck.
Are you sure Transaction log can restore a table?
I thought it only held the transactions, not the whole database schema. That's what backups are for.
In other words, in the Full Recovery model, SQL server writes every update, delete etc. but it doesn't actually save a copy of some table or table schema script from which you could restore a dropped table.
I suppose its possible to manually recreate a table that was dropped by examining the log transactions, but its sure not something I'd want to have to do.
vasuki replied to Ravi Kumar
FLASHBACK TABLE table_name TO BEFOR DROP;
Any one send frequently asked Important questions in C# .Net, ADO .Net, Asp .Net and Sql Server. . . . . . . . tx in Advance. . . . . . Hi, Find this. . (B)What is an IL? (B)What is a objects in Remoting? (A) What are the ways in which client can create object on server in CAO model? (A) Are CAO stateful in nature? (A) To create objects in CAO page ? (I) Can we post and access view state in another application? (I) What is SQL Cache Dependency in ASP.NET 2.0? (I) How do we enable SQL Cache Dependency in ASP.NET 2.0? (I) What is Post Cache substitution? (I) Why Config”? (B) What is a SESSION and APPLICATION object? (A) What is the difference between ‘Server.Transfer’ and ‘response. Redirect’ ? (A)What is the difference between Authentication and authorization? (I) what proper? (A) If client side validation is enabled in your Web page, does that mean server side code is not run. (A)Which JavaScript file is referenced for validating the validators A)What is the use of <%@ page aspcompat = true %> attribute? B) Explain the differences between Server-side and Client-side code? (I)Can you explain Forms authentication in detail? (A)How
please help me in configuring Oracle Database creation. . . Hi. . Oracle 10g Server DB is installed in my PC. Now my system acts as server and different clients will be connected to this. My ques is. . . As server version is installed, what type of database I should create out of 4 templates defaultly provided. . (custom db, datawarehouse, general db, transaction processing. . ) After i create a new database, the onsite team will export some oracle database into my system and later i need to import this data from sql server. Please help me in configuring the database creation. Thank you, Ramm There are four
net ADO is designed primarily for connected access ADO.net the disconnected access to the database is used In ADO you communicate with the database by making calls to an OLE DB provider. In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to or the APIs provided by the underlying data source. In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database. On order to get assembly info which namespace we should import? System.Reflection Namespace How tab”) This will fill the dataset with the records starting at 5 to 15 .NET Database interview questions How do you call and execute a Stored Procedure in.NET? Give an Products”) DataGrid1.DataSource = ds.Tables(”Products”) What is the maximum length of a varchar in SQL Server? Answer1 VARCHAR[(n)] Null-terminated Unicode character string of length n, with a maximum of
the reverse process of normalization. It is the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced key of the junction table. It will be a good idea to read up a database designing fundamentals text book. What's the difference between a primary key and a unique when you should go for them? User defined data types let you extend the base SQL Server data types by providing a descriptive name, and format to the database. Take for example, in your database, there is a column called Flight_Num which appears in many tables. In all these tables type is used to store Boolean information like 1 or 0 ( true or false ). Until SQL Server 6.5 bit data type could hold either a 1 or 0 and there was
Upgrading SQL 6.5 to 2000 then to 2005. Failing at first hurdle. Need some urgent help chaps " at least when you have stopped laughint from shock" I have inherited a sql 6.5 server running on an old nt4 server. "ok pause for laughter" As you can imagine this server is crap, slow, unreliable and all the rest. Problem is its critical. Being new here shot of this system asap. So began the upgrade path for 6.5 "created an SQL 2000 server on a second machine and have tried to use the SQL server upgrade wizard.All seems to go ok untill it comes to the Upgrade of