Backup a MSSQL database

In order to create a MSSQL database backup your first step will be to connect to your server via RDP. You’ll need the servers IP address, your admin username, and the password to login.

RDP_login

Find SQL Server Management Studio in the Start menu and right-click it so it can be run as administrator

RDP_StartToSQL_marked

Once the login screen has loaded you’ll see the following. The default settings are usually fine for logging in.

SQLStudio_login_marked

Navigate to the database you would like to backup, right-click on the database name, select Tasks then Back Up

SQLStudio_BackUP_marked

You can adjust and settings on the following screen and backup location, if needed, then click the OK button to start creating the backup. There will be a confirmation when the backup it complete.

SQLStudio_BackupDone

Was this article helpful?

Yes (1)
No (4)

We're sorry you didn't find this article very helpful. Please help us improve it by leaving your feedback below.

Error