by MYLE
18. June 2010 16:04
thank good for backups all I have to say
a company I work for has a administrator and he/she delete the content of a table Bugger I had rrestore 1 table only as data had added after a backup as done
heres what I did
- trun off the SQL and copy the SQL files to a differnace place (backup only if it did not work)
- them did the restore of the database
- open up MSAccess and did a make table of the missing table data
- copied back the old live database
- turn the index autonumber off on the table that was missing the data
- did a update of the data of the form the make table I created in step 3
- turn on the autonumber and made it the key feild again
and it work
e6297bfa-a711-44f9-b0f5-adaaccf275c1|0|.0
Category: Backups, SQL
Tags: Backups