Restore MS SQL Database

Navigate to: Main Menu > MS SQL > Databases > Select a database > Click the Restore tab.

This tool allows you to replace your current database with data from a standard MS SQL backup file (.bak). This is commonly used to deploy a database developed on your local machine to the server.

Critical Warning

Restoring a database is a destructive action. The process completely overwrites the existing database. Any data currently stored in the online database will be erased and replaced with the contents of the backup file.

Restore Methods

1. RESTORE FROM BACKUP LOCATION (Recommended)

Use this method if your backup file is large (over 100MB) or if you have a slow internet connection.

• Prerequisite: You must first upload the .bak file using the Backup file manager or FTP.
• Workflow: Select the file from the list and click RESTORE. Because the file is already on the server, the process is fast and immune to connection timeouts.

2. UPLOAD AND RESTORE

Use this method for quick updates using small backup files located on your computer.

• Workflow: Click BROWSE or drag-and-drop a .bak file to the window. The browser will upload the file and trigger the restore immediately after the upload finishes.

Configuration: Change default schema to 'dbo'

You will see this checkbox in both restore forms. We highly recommend leaving this checked.

• The Problem: When you move a database from one computer to another, the "User" attached to tables often causes permission errors because that specific user doesn't exist on the new server.
• The Solution: Checking this option automatically re-maps all database objects to the dbo (Database Owner) schema. This ensures that your primary login has full permissions to access tables and run stored procedures immediately after the restore.