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:
- 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
- Locate Your Database
In Object Explorer, expand your server > Databases > Right-click your database > Tasks > Back Up…
- Set Backup Type
In the backup window, ensure Backup type
is set to Full. Remove existing destination entries.
- Choose Backup Destination
Click Add… and enter a full path like C:\Backup\myBackup-Full-050109.bak
.
- Enable Overwrite Option
On the left panel, select Options > Check Overwrite all existing backup sets.
- Start the Backup
Click OK to begin. A success message should confirm completion.
- 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?