Take the 2-minute tour ×  I have a full back up of a database, I
want to update some records in some table in the current
database from its old backup without affecting other records.
What is the best way to do this?  Basically I want to get some
records from the old backup update old values to the current
database without doing a restore, what are my options?
share|improve this question add comment  migrated from
stackoverflow.com Dec 28 '12 at 13:38  This question came from
our site for professional and enthusiast programmers.  3 Answers
up vote 6 down vote accepted  You cannot access the records in a
database backup without restoring it to a database. You can
however restore it to a different database from the one that it
was backed up from.  The following link illustrates how to do
this using Transact-SQL: http://msdn.microsoft.com/en-
us/library/ms190447(v=sql.105).aspx  and in Management studio:
http://msdn.microsoft.com/en-us/library/ms177429(v=sql.105).aspx
Then once you have the new database you c