Archive for

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

Restore MS SQL 2008 Database Backup (.bak) To A New SQL Server/Instance

Here’s how to restore an MS SQL .bak file onto a new SQL server/SQL instance with a simple script. I’ll show what to edit in the example below to restore the database My_DB.bak onto your new server First things first, if you have no idea what the database name and file paths are within your … Continue reading