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.
