1

I deleted table in Microsoft SQL Server 2012. Now I need data from deleted table. How to recover deleted table without using tool.

Improve this question
2
  • 1
    You can't, it's gone unless you have a backup to restore. Commented Mar 1, 2017 at 13:47
  • So you have a backup of your database and you want to restore a single table from it? Then restore the whole database into a new (temp-)db on the same server. Then you can use SELECT * INTO TableName FROM backup_database.TableName. If you don't have a backup... sorry Commented Mar 1, 2017 at 13:48

1 Answer 1

Reset to default
1

recover the deleted table with the help of Transaction Log and LSNs.For more details please visit the below detailed link

Recover Deleted row Or Deleted table from SQL server

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.