Get 1 table form a Backup of a SQL database

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

 

  1. trun off the SQL and copy the SQL files to a differnace place (backup only if it did not work)
  2. them did the restore of the database
  3. open up MSAccess and did a make table of the missing table data
  4. copied back the old live database
  5. turn the index autonumber off on the table that was missing the data
  6. did a update of the data of the form the make table I created in step 3
  7. turn on the autonumber and made it the key feild again

and it work

Dislexia

I see people have commented about my style of writting.
Well I have dislexia so spelling is not one of my good points
but when it comes to reading/written code thats the easy bit.

 

 

Poll

What Search Engine Do you use




Show Results

Disclaimer of Liability

While every effort will be made to ensure that the information contained within this website is accurate and up to date, The Company's listed with this web site and any associated parties, make no warranty, representation or undertaking, whether expressed or implied, nor does it assume any legal liability, whether direct or indirect, or responsibility for the accuracy, completeness, or usefulness of any information.

 

Google Ads

Most comments

carpet cleaning forest lake carpet cleaning forest lake
1 comments
us United States
carpet cleaning capalaba carpet cleaning capalaba
1 comments
us United States

RecentComments

Comment RSS