How can I restore a backup without overwriting ALL of the tables? I have a SQL Server database with 3 tables.  I need to restore a backup that contains 4 tables, while still keeping the old data in the original 3 tables.  Is this possible?
Restore the backup to a database with a new name.  You get to keep the old and new and can move tables between them with a little work