title: replace table by other table
body: <p>We have this current database which we need to replace some tables by anther tables from backup database. we are using sql server 2008 r2 and I want to know how to do overwrite or replace current tables by new table having same structures. thanks in advance. </p>