Technical Guides
      Back to home
      1. Knowledge Base
      2. Technical Guides

      Moving a SQL DB from one host to another.

      If you want to backup your SQL DB and copy it to another host, here is a basic guide for this.

      🧭 Step-by-Step Guide: Backup and Restore SQL Server Database

      🔹 Part 1: Backup the Database on the Source Server

      You’ll use SQL Server Management Studio (SSMS) for this.

      1. Open SSMS and connect to the source SQL Server.
      2. In Object Explorer, expand Databases, right-click the database you want to back up, and choose Tasks > Back Up....
      3. In the Backup Type, select Full.
      4. Under Destination, choose Disk and click Add to specify the .bak file location (e.g., C:\Backups\MyDatabase.bak).
      5. Click OK to start the backup.

      📺 How to BACKUP DATABASES in SQL Server Management ... walks you through this process with clear visuals.

       

      🔹 Part 2: Move the Backup File to the Target Server

      • Use a USB drive, shared folder, or secure file transfer to copy the .bak file to the target server.

       

      🔹 Part 3: Restore the Database on the Target Server

      1. Open SSMS and connect to the target SQL Server.
      2. Right-click Databases and choose Restore Database....
      3. Select Device, click the ellipsis (...), then Add and browse to the .bak file.
      4. Choose the backup set and click OK.

      📺 SQL Server Database Restore using SSMS shows this in action.

       

      🔄 Refreshing the Target Database Later

      When you want to refresh the target database with new data from the source:

      Option 1: Repeat the Backup/Restore Process

      • Just overwrite the existing database on the target server using the same steps above.

      📺 Backup and restore your Microsoft SQL Server database explains how to safely overwrite a database.

      Option 2: Use a Scripted Approach (Advanced but Free)

      • You can automate the backup and restore using T-SQL or PowerShell scripts.
      • This is faster and repeatable once set up.

      📺 Ultimate SQL Server Backup & Restore Guide | Protect Your ... dives into scripting and automation.

      🧠 Bonus Tips for Non-DBAs

      • ✅ Always verify the backup file before restoring: RESTORE VERIFYONLY FROM DISK = 'C:\Backups\MyDatabase.bak'
      • ✅ Use WITH REPLACE in the restore script if you’re overwriting an existing database.
      • ✅ Keep backups on a separate drive or cloud for safety.

      📺 Introduction to SQL Server Database Backup and Restore gives a great overview of concepts if you're curious to learn more.