Restore a MSSQL database

You can restore a database to a previously backed up version of itself. Connect to your server via RDP. You’ll need the server’s IP address, your admin username, and the password to the login.

RDP_login

 Find SQL Server Management Studio in the Start menu, then right-click on it run as administrator.

RDP_StartToSQL_marked

Once the pop up box appears, you will be asked to log into the database server. The default settings are usually fine.

SQLStudio_login_marked

 Navigate to the database you would like to restore, right-click on it, then select Tasks > Restore > Database.

SQLStudio_Restore_marked

Your default source may be set to Database, which will contain backups placed in SQL Management studios’ backup folder.

SQLStudio_RestoreMenu_marked

If you want to restore from a back that exists elsewhere on the server, you can select the Device option. After choosing Device, you will need to add the database file to the restore list by browsing to it’s location on the server.

SQLStudio_RestoreNav2File_markedWhen you restore from a device, you will need to overwrite the original data on the Options page.

SQLStudio_RestoreOverwrite_marked

You can click “OK” to start the restore process to rollback your database.

Was this article helpful?

Yes (0)
No (0)

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

Error