General discussion

Locked

updating a SQL object

By c-mackenzie ·
I have a SQL database(2000) which I had to restore from a backup on the 31st of December because of problems that occured to it in the first few days of the new year causing much corruption to the 05 data. However, some work had been carried out to incidents that had occured in december in the first few days of January which now isn't showing in the live database, there are incomplete incidents that had been completed. I did create a backup of the database on the 4th of Jan before restoring the 31st of dec backup so i still have the work that was carried out. What is the quickest way that I can update the live database with the work that was carried out on the frist few days of January? Bear in mind I need to import the data based on the unique incident reference number. The incident data is spread throughout a number of tables.

Any help is much appreciated.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by josh In reply to updating a SQL object

Firstly, what software do you use to backup, What do you backup to (TAPE, ect.) and how are you backing up (System wide as one file or just files/folders that you select)?

Collapse -

by c-mackenzie In reply to updating a SQL object

I use the SQL back up service which i've been able to restore the 4th of jan backup to. I can now browse to this data on the SQL server that has the live database so accessing the object data isn't a problem.

Collapse -

by NZ_Justice In reply to updating a SQL object

I would suggest the quickest way would be to update the live database would be to use a storedproc and just redo the work but with out the curupt data. iF ti is reentering data you may want to exclude xurrupt data, you should be able to erite that into your storedproc. You should be able to build the stoeredproc from your backedup database.

Collapse -

by NZ_Justice In reply to

This is the spell checked and edit version of my answer might be easier to understand.

I would suggest the quickest way to update the live database would be to use a storedproc and just redo the work but with out the corrupt data. If it is re-entering data, you may want to exclude corrupt data, you should be able to enter the exclusion into your storedproc. You should be able to build the stoeredproc from your backed up database.

Collapse -

by c-mackenzie In reply to

Thanks that helped me out.

Collapse -

by c-mackenzie In reply to updating a SQL object

This question was closed by the author

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums