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

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