Managing SQL Server 2012 Databases with WebsitePanel

Unlike other hosting control panels, WebsitePanel not only enables you to create Microsoft SQL Server 2012 databases but also provides an ability to backup and restore databases.

Creating Databases

  • Login to WebsitePanel
  • Select Databases | SQL Server 2012

Figure_1

  • Select Create Database
  • Provide a name for your database and click Save button

Figure_2

  • Select Create User
  • Provide a username, password and associate with the database by selecting the database name from the Default Database drop down. You should also select the checkbox located near the database name.

Figure_3

You can now make use of Microsoft SQL Server 2012 or Microsoft SQL Server 2012 Express from your computer to access and manage the database remotely using either the IP address or host name. You will get the required information if you select the relevant database name as shown below

Figure_4

In order to take a backup of your database, select your database name and click on the Maintenance Tools panel

Figure_5

Select the Backup button, provide a backup filename and click Backup button. Alternatively, you can either download the backup or save it on the server where your site is hosted.

Figure_6

You can easily restore a SQL Server backup by selecting the Restore button. You can either upload a backup file by selecting the Browse button or locate the backup from the server.

Figure_7

Looking for quality web hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , , | Posted under DotNetPanel Administration, MSSQL | RSS 2.0

Author Spotlight

Anand Narayanaswamy

Anand Narayanaswamy

Anand works as a freelance writer based in Trivandrum, India. Anand runs NetAns, which provides hosting for developers and small scale businesses. He also provides blog installation services. He runs his own blog - www.learnxpress.com and maintains a video portal which publishes videos related to web hosting, windows, social media and other technology related matters- http://tv.learnxpress.com You can follow Anand on twitter - @visualanand

2 Comments on Managing SQL Server 2012 Databases with WebsitePanel

  1. Eaton says:

    When will SQL 2012 databases be available for existing ASP accounts? I still only see 2008 in my control panel.

  2. Bryan Bensing says:

    Same here. I can only see MSSQL 2008!

Leave a Reply

Your email address will not be published. Required fields are marked *


2 × = 4

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>