Sponsored

Recent Blog Entries

  • Well once in a while there are gadgets which you do not have and also Rocket League Credits you need to get them. The simplest manner to get them is thru the buying and selling machine When buying and selling, you could both alternate your credit for gadgets or you could alternate gadgets for ...
  • If you have limestone floors in your home, chances are you want to know how to clean it properly. Cleaning your limestone floor can actually be challenging at times. This is because there are a number of factors to consider when attempting to achieve the desired outcome. These factors include the su...
  • Everyone wants to make sure their marble floors look like new, but not many people know how to restore their marble flooring. Alongside stains and scratches, your marble floor can also lose its shine and luster if you don't clean it regularly or if the floor wasn't sealed correctly when it was first...
View All

Sponsored

Microsoft SQL Server Management Studio 2012

  • Managing SQL Server 2012 Databases with WebsitePanel

    How to create database on your WebsitePanel control panel and manage with Microsoft SQL Server 2012.

     

    Creating Databases

    • Login to WebsitePanel
    • Select Databases | SQL Server 2012

     

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

     

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

     

     

    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

     

     

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

     

     

    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.

     

     

    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.

     

Sponsored

Sponsors