Replace Record in Table from A Backup of the Same Database
Posted on 2011-05-05
I have a Live Database called LiveDB.
I restored a copy of a backup that was taken of LiveDB two nights ago. The restored database is called LiveDB_restore
Today, by accident, I overwrote one record on a table in the LiveDB. I want to replace that record from the data in LiveDB_restore.
The table name is Loans.
The primary key field in Table Loans is called RecID.
The RecID = "820d0d09"
I would like to accomplish this via a query in SQL Server Management Studio
Please help me.