This tag is associated with 2 posts

Restore SQL database from .bak as a different name

Follow the below to restore an MS SQL database backup (.bak) as a different name, changing the paths to the .bak, .mdf and .ldf files as appropriate in your environment. The only caveat with this is that the Logical Names of the database will remain the same as the database it was restored from, though … Continue reading

Copy A Table From One Database To Another In MS SQL 2008

This can be useful if you’ve just restored a database from backup under a different name to the live database, and need to copy only individual tables and the table data from the restored database to the live one. Lets assume that the live database is called Live_DB and the restored database is called Restored_Live_DB … Continue reading