+91 88 00 563434 sales@webhostingpeople.net

Managing SQL Server 2012 Databases with WebsitePanel

Managing SQL Server 2012 Databases with WebsitePanel

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

Figure 13

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

  • 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.
Figure 35

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:

Figure 42

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

Figure 5

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.

Figure 6

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.

Figure 7

Are you on the lookout for fast-reliable-affordable website hosting? , Strive WebHostingPeople