WebSitePanel User Guide – SQL Server Databases

0
1750

Database management is one of the most important parts of hosting a site. However, there are still many webmasters have difficulties while creating, backing up SQL server databases or other related tasks.

As recognized easy-to-use control panel, WebSitePanel is an effective tool to manage database. In this article, we list the basic WebSitePanel user guide on SQL server databases, offering efficient methods to manage your databases.

Creating a SQL Server Database

First of all, you need to sign into the WebSitePanel with your user name and password.

create sql server database1

Once you sign in, you can see your Account Home page.

create sql server database2

There are several icons on this page. Place your mouse on “Databases” and click the version of SQL server database that you want to create, then you can see the list of databases and users of this version of database. Here, we take creating a SQL server 2014 database for an example.

create sql server database3

Click “Create Database” button to create a new SQL server database.

create sql server database4

Fill in database name and click “Save” button to finish the creation of the new database.

Creating a Database User

After creating the database, the next step is creating a database user account and binding it with the database

create a database user1

Click “Create User” button to create a database user account.

create a database user2

Fill in user name, password and tick the database you want this account to associate with at “Databases” sections. In this way, this account will be granted as “db_owner” in the ticked database.

You can also select “Default database” as well. Remember, once you select a database as the default database, its name could be omitted from connection strings of applications.

After all the information filled, click “Save” to finish creation of database user.

Backing Up SQL Server Database

Open the properties page of the database you want to back up.

back up sql server database1

Click the “Backup” button.

back up sql server database2

Fill in backup name and choose a method you prefer to store it.

According to the size of  your database and transaction log, the backup could be very large. You can tick the “ZIP Backup” so your backup will be compressed. If not, the backup will be produced in BAK format.

You also need you make a choice of where to store your backup. You can download it via HTTP to your computer or copy it to the folder in your hosting space. If you choose to copy the backup to folder, you will need to specify the path leading to the folder.

Restoring SQL Server Database

Open the properties page of the database you want to restore and click the “Restore” button.

restore sql server database

Check “Upload File” and  click “Choose File” button to select backup file from your local file system or tick “Hosting Space File” button to pick backup file from hosting space file system.

Click “Restore” to finish restoration.

Truncating Database Files

To truncate the database files you just need to open the properties page of the database whose files you want to truncate and click the “Truncate Files” button in the Housekeeping Tools section.

Truncate-database-files

Connecting to SQL Server Database

To see the connection information you need to click “View Account Summary” at the right side of your Account Home.

connect to sql server database 1

Scroll down the page to “Databases” section.

connect to sql server database 2

If the external connections to SQL server are available, you will see the server address and the sample of connection string for classic ASP and ASP.NET at this section.  By using this address, you are able to manage your databases by MS SQL Server Management Studio at your own PC.