How to Backup and Restore MSSQL database in Windows Dedicated Server ?

Windows Dedicated Server allows you to take backup and restore the Sql Database using Sql management studio.

To take backup of Sql Database :

1.Login into the sql server using windows authentication
2.Expand the database
3.Right click on the database for which you want to take the backup
4.Click on Tasks–> Backup
5.Click on Add –> Enter the path where you want to keep the database backup
6.Click on ok

To restore the sql database :

1.Login into the sql server
2.Right click the database which you want to restore
3.Click tasks –> restore –>database
4.In source click on Device and choose the database location
5.Click on options
6.Choose overwrite existing database ( WITH REPLACE)
7.Click on ok