Hi all experts,

One of our customers lost its transaction data during one period, say April
1 to april 30, in live MSSQL 2000 database, and those data can be found back
in backup performed manually one week ago.

Anyone out there can help me get lost data back from backup and merge into
its live db? I am new to it, any suggestion is much appreciated.

--
Best regards,
Lurc

OK

Restore the backup first of all

The next part might be very difficult.

You can easily compare your backed up version for rows that it contains vs
what is in the production system. You need to be careful about doing it in
the right order for integrity.

The Updates may be a little more difficult.

What if in the restored version you have a row that reads

CustomerID CustomerName CustomerJoinDate CustomerAge
CustomerAdressID
1 John 10/10/2001 30
14

In the production version you have

CustomerID CustomerName CustomerJoinDate CustomerAge
CustomerAdressID
1 John 10/10/2001 31
16



Since the restored version we have updated the Customer Age to 31 from 30
and the user has moved address also.

What do you want to do with this row?

There are going to be some attributes in a row in production that have been
amended correctly and maybe some of the other attribute details are in the
restored version.

Not pretty.

As |I mentioned if it in simply INSERTs then you should just be able to
compare PK values.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"lurc" <lurchot (AT) hotmail (DOT) com> wrote

Hi Allan,

Thanks for your prompt reply.
--
Best regards,
Lurc