Previous Topic Next Topic

Unwanted deleted rows from database

Solved/Closed
anthonymc232 Posts 1 Registration date Tuesday June 9, 2015 Status Member Last seen June 9, 2015 - Jun 9, 2015 at 06:38 AM
barrygr Posts 1 Registration date Wednesday June 10, 2015 Status Member Last seen June 23, 2015 - Jun 23, 2015 at 04:20 AM
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
Related:

1 response

Answer 1 / 1
barrygr Posts 1 Registration date Wednesday June 10, 2015 Status Member Last seen June 23, 2015 1
Jun 23, 2015 at 04:20 AM
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

Similar discussions

Deleted Message icon
thina -
BunoCS -

1 response
How do I fix a corrupted MS Access database?
JohnBradl -
Punnu -

4 responses
Spam deleted Mail Recovery
Pankaj -
sowndranayaki -

2 responses
Message icon deleted
Dorji -
BunoCS -

1 response
How to retrieve deleted messages from Truecaller
Cuttima -
dwebb -

2 responses