Can I restore the content of a table after that I deleted all the rows inside it?

Vote count:

0

I am very new in Microsoft SQL Server and I am not so into databasess.

Yesterday I made an error and I deletd all the rows inside the wrong table (I should delete the records in another table)

So now it is very important to me restore in some way all the deleted records in this table (only these records and not all the DB, if it is possibile in someway).

for completeness the table is named dbo.VulnerabilityWorkaround and have the following fields:

• 
  

  Id: int not null (is the PK)

  
  


• 
  

  Description: varchar(max), not null

  
  

I think that the SQL Server retains the information related to the deleted records in a log file (or in something like it, maybe a DB table...I don't know)

Can in some way restore my original dbo.VulnerabilityWorkaround by a query or something like it?

asked 2 mins ago

AndreaNobili

1,754