Unwanted deleted rows from database

[Solved/Closed]
Report
Posts
1
Registration date
Tuesday June 9, 2015
Status
Member
Last seen
June 9, 2015
-
Posts
1
Registration date
Wednesday June 10, 2015
Status
Member
Last seen
June 23, 2015
-
Hi,

I deleted by accident 28 row from SQL server 2005 database (via SQL Management Studio Express) from table ParameterDefinition with columns (Id, Name, PluginId, Description, DefaultValue).
My command was: delete from ParameterDefinition where Name = 'RateOfVat'.
I only wanted to delete one row but I haven't realized that there are more such rows.

Do you know how to repair it to original state or how to find out (from logs) what was deleted? thanks

1 reply

Posts
1
Registration date
Wednesday June 10, 2015
Status
Member
Last seen
June 23, 2015
1
Restore from backup?
Is the database setup with recovery model as "FULL"?
Is that from some app?

Read: http://community.office365.com/en-us/f/154/t/255789.aspx
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month