There was a problem loading the comments.

Back Up SQL Server Database via SQL Server Management Studio

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

How to Back Up SQL Server Database via SQL Server Management Studio

✅ Supported SQL Versions:

  • SQL Server 2005
  • SQL Server 2008 / 2008 R2
  • SQL Server 2012, 2014, 2016, 2017, 2019, and 2022

🔧 Step-by-Step Instructions:

  1. Connect to SQL Server
    Use the connection info provided in your email:
    SQL Server Name: IP-Address,Port
    Authentication: SQL Server Authentication
    Username/Password: From your control panel
  2. Locate Your Database
    In Object Explorer, expand your server > Databases > Right-click your database > Tasks > Back Up…
  3. Set Backup Type
    In the backup window, ensure Backup type is set to Full. Remove existing destination entries.
  4. Choose Backup Destination
    Click Add… and enter a full path like C:\Backup\myBackup-Full-050109.bak.
  5. Enable Overwrite Option
    On the left panel, select Options > Check Overwrite all existing backup sets.
  6. Start the Backup
    Click OK to begin. A success message should confirm completion.
  7. Restore Note
    Use the .bak file to restore on your live server through SSMS or your hosting control panel.

⚠️ Shared/Reseller Hosting Limitation

Customers on shared/reseller hosting cannot use SSMS for backups on the live server. Please use the online control panel or contact our support team for manual assistance.

 

Need Windows Shared Hosting?


Share via
Did you find this article useful?  

Related Articles

Tags

© Softsys Hosting