In contrast to different internet hosting management panels, WebsitePanel not solely lets you create Microsoft SQL Server 2012 databases but in addition offers a capability to backup and restore databases.

Creating Databases

Login to WebsitePanel
Choose Databases | SQL Server 2012

Choose Create Database
Present a reputation on your database and click on Save button

Choose Create Person
Present a username, password and affiliate with the database by deciding on the database identify from the Default Database drop down. You also needs to choose the checkbox positioned close to the database identify.

Now you can make use of Microsoft SQL Server 2012 or Microsoft SQL Server 2012 Express out of your pc to entry and handle the database remotely utilizing both the IP tackle or host identify. You’ll get the required info if you choose the related database identify as proven under:

With a view to take a backup of your database, choose your database identify and click on on the Upkeep Instruments panel

Choose the Backup button, present a backup filename and click on Backup button. Alternatively, you possibly can both obtain the backup or put it aside on the server the place your website is hosted.

You may simply restore a SQL Server backup by deciding on the Restore button. You may both add a backup file by deciding on the Browse button or find the backup from the server.