How to Create an Empty MS SQL Database

This guide explains how to create a new, empty MS SQL database container on our servers. Once created, you can use this container to deploy your data using scripts, backups, or file attachments.

Prerequisites & Important Considerations

• Hosting Plan: You must have an active hosting package (Free or Paid) that includes MS SQL support, or a standalone MS SQL package.
• Version Compatibility: Be careful when selecting the MS SQL Server version. If your local development environment uses an older version (e.g., 2014) and you select a newer version here (e.g., 2019), you will not be able to easily move the database back to your local computer without upgrading your local software.
• DNS Propagation: The system creates a unique server address for your database. While creation is instant, due to global DNS replication, it may take up to 30 minutes for the database to become accessible via the internet.

Step-by-Step Instructions

1. Navigate to Create Database
   • In the control panel, navigate to the MS SQL section.
   • Click on Create database in the side menu.
2. Fill in the Details
   • MS SQL plan: Select the hosting package you want to use for this database.
   • Database name: Enter a unique name for your database.
   • Zone name: Select the domain zone (e.g., somee.com).
   • MS SQL Login: Every database requires an owner (Dbo). You have two options:
     • Select an existing login from the list.
     • Select - Generate new login - to have the system create a new login for you automatically.
   • MS SQL Server version: Choose your desired version. (Note: For paid packages, we highly recommend using non-Express versions for better stability and performance).
3. Create
   • Click the CREATE DATABASE button.
   • The process may take several minutes to complete. Please be patient.

What Happens Next?

Once you click create, the system performs several automated tasks:

1. Unique Server Name: A unique DNS record is created for your database. This allows flexibility, meaning if we need to migrate your database to a different node for performance, your connection string won't necessarily need to change, though DNS propagation will apply.
2. Backup Location: A dedicated backup storage area is created. This is where you will upload your .mdf, .ldf, or .bak files for deployment.
3. Empty Container: The actual empty database is initialized on the server.

After the process finishes and DNS propagates, you are ready to deploy your data.