Currently I deleted one
table from the database. But now I want some of the information from that table.
Please suggest how to restore or get back the table.
I am using SQL Server 2008 R2.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You can restore the BACKUP with a different name in the same instance and follow steps below.
1) restore the database (
right click on databases >
Restore ( it can be in the same instance )) with a differente name.
2) In this new database ( The restored one ) , open
tables , search the table you've deleted,
Script table as >
CREATE TO. This will crate a Script. Execute it on the old database ( the one you have deleted the table). It will create the structure of that table.
3) Now you can do something like this:
USE [Old Database] GO SELECT * INTO [the blank table you've created in the new database] FROM [the table on the backup, that has Data]
This will copy the data from the backup table, to the table you created.
If you backup your transaction log you will be able to restore up to a given point in time using the stopat option.
As previously mentioned you should restore it on a different database.
That way you will be able as much data back as possible.
RESTORE LOG AdventureWorks FROM AdventureWorksBackups WITH FILE=4, NORECOVERY, STOPAT = 'Apr 15, 2020 12:00 AM';
Please follow below mentioned steps:
please mentioned the issue which you are facing during the above mentioned activity