DB Server

Available in Classic

In DB Server, you can create or delete MSSQL Server, as well as check the list of MSSQL Server in operation. In addition, you can change the specifications for the MSSQL Server in operation, or manage admin (User) accounts.

DB Server page

The basics of using MSSQL Server are as follows:

View MSSQL Server list

You can check the information of each server from the list of MSSQL Server that have been created and are in operation. To check the information, follow these steps:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. If the list of created MSSQL Server appears, then check the summary information or click an MSSQL Server to check the details.
   
   • DB service name: service name of MSSQL, a group that classifies MSSQL Server by role. It generally refers to a server group that consists of one Principal Server, one Mirror Server, and multiple Slave Servers. MSSQL Server with the same data are referred to as one Service
     • : click to change the Service name
   • DB Role: roles of the MSSQL Server
     • Principal: Master Server when the high availability support is selected
     • Mirror Master: Standby Server when the high availability support is selected. If Master Server fails, then it automatically performs the role of Master
     • Stand Alone: the single Server when the high availability support is not selected
   • MSSQL Server name: name of the MSSQL Server
   • MSSQL Server type: type of the MSSQL Server and its available memory
   • Monitoring: go to the monitoring page
   • DB Status: directs to the view MSSQL Server details page
   • DB access port: port number being used by the MSSQL Server
   • Zone: indicates the Zone to which the MSSQL Server belongs
   • Private domain: information of the Private domain
   • Public domain: information of the Public domain which allows external access
     • This is displayed only when Public domain is enabled through Public domain management features in the Manage DB menu
   • Data storage: size of the data storage in use (available capacity)
   • Data storage type: type of data storage in use
   • Data storage capacity: available capacity and used capacity of the data storage in use
   • Status: status of the MSSQL Server
     • Creating: status in which the MSSQL Server is being created with the information entered by the user
     • Configuring: status in which the MSSQL Server is being configured after being created with the information entered by the user
     • Running: status in which the creation and configuration of the MSSQL Server have been completed with the information entered by user, and access to MSSQL from the application server is available
     • Deleting: status in which the MSSQL Server is being deleted with the information entered by the user
     • Stopping: status in which the MSSQL Server is being stopped with the information entered by the user
     • Restarting: status in which the MSSQL Server is being restarted with the information entered by the user
   • Creation date: date when the MSSQL Server was created, the initial point when the server entered creating status
   • Running date: date when the MSSQL Server started running, the initial point when the server entered "running" status
   • ACG: ACG name and ID used in the MSSQL Server
     • : click to move to Server > ACG
     • [View rules] button: click to display the detailed rules applied
   • Database Config: Config applied to the MSSQL Server
     • : set the DB Config Group when clicked
   • DB engine version: version information of the MSSQL installed on the Server
   • High availability: whether high availability function is enabled (Y or N)
     • : set whether to use high availability when clicked
   • Backup storage period (backup time): the configured backup file storage period and backup cycle, if the backup function is enabled
     • : click to enable or disable backup or set the file retention period and backup cycle
   • Collation: MSSQL character sets installed in Server
   • Scheduled Reboot time: scheduled time for restarting the Server

Create MSSQL Server

Follow these steps to create an MSSQL server:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. Click [Create DB Server].
   
4. When the subscription request page appears, proceed with the following steps in order:
   • 1. Set server
   • 2. Set DB
   • 3. Final confirmation

1. Set server

Follow these steps to create Server to install MSSQL by entering the settings:

1. When the set server page appears, check the type of DBMS you want to install to the server from DBMS type.
   
2. Check the version and character set information of the MSSQL to be installed.
   • DB engine version: information of the MSSQL version that can be created in NAVER Cloud Platform
   • DB character set (Collation): character set information of MSSQL that can be created in NAVER Cloud Platform
     • Korean_Wansung_CI_AS: Korean letter complete type, no distinction between upper and lowercase characters or accents
     • SQL_Latin1_General_CP1_CI_AS: English version's default value, no distinction between upper and lower characters or accents
3. Set items related to Zone and MSSQL Server, which are needed for the creation of the MSSQL Server.
   • Zone: select a zone to create the MSSQL Server in
   • DB Server type: select the MSSQL Server type to be created and available memory according to the server type
   • Data storage type: click to select the storage type for saving DB data, between SSD and HDD
     • The settings can't be changed after the creation of the MSSQL Server.
   • Data storage capacity: view the storage capacity for saving DB data
     • 100 GB is assigned upon initial creation of an MSSQL Server
     • The capacity is automatically added in 10 GB units and charged as data increases
     • Up to 2000 GB is supported
4. Set Support high availability for the availability of the server to be created.
   • When selected, redundancy is configured with two MSSQL Server: Principal Server and Mirror Server
   • Performs a Failover for automatic recovery in case of failure
   • When selected, set backup file retention period and backup time (default: 1 day, automatic)
   • When selected, disabling the storage of backup files is not possible
   • When selected, additional fees will be incurred
   • Mirror Server is not accessible by the user
5. Check the applicable pricing plan information when using Cloud DB for MSSQL.
   • Pricing plan: an hourly pricing plan, which is billed based on the hours used, is applied by default, and it is changed according to the server specifications and storage capacity
   • For more information, click pricing information
6. Set the rest of the items required for the creation of MSSQL Server.
   • DB Service name: enter a group name that classifies MSSQL Server that will be created by role (<example> mssql-service)
     • The name must be 3-15 characters long and can only include Korean letters, English letters, numbers, and the hyphen (-)
     • A duplicated name can't be used
   • Set ACG: ACG (Access Control Group) is created automatically
     • The detailed settings for the ACG are available from Server > ACG in the console
7. Click [Next].

2. Set DB

Follow these steps to set the information for the MSSQL to be installed:

1. When the Set DB page appears, set items needed for the creation of the MSSQL Server.
   
   • USER_ID: enter the account ID of the MSSQL Server admin
     • The ID must be 4-16 characters using English letters, numbers, and the underscore (_)
     • It must start with an English letter
     • Predefined reserved words can't be used
   • USER password: enter the account password of the MSSQL Server admin
     • The password must be 8-20 characters long and can only include English letters, numbers, and special characters, with at least 1 of each
     • The special characters ` & ₩ " ' / or spaces can't be used
   • DB access port: enter 1433 or between 10000 to 20000 as a TCP port number to allow access to the MSSQL Server that will be created
     • Default: 1433
     • The port number can't be changed after it is specified
   • DB Config settings: view the optimized basic settings provided by NAVER
     • A Config Group created in advance can be applied when you create a server
   • Collect DB log: check the provision of log collection and viewer function for error logs
     • Cloud Log Analytics integration
2. Set whether to use the backup for the server to be created.
   • Backup settings: set whether to use the backup, backup file retention period, and backup time
     • Backup file retention period: click and select the period to store the backup file in a separate backup storage
       • For point-in-time recovery, the Backup file is stored for the maximum retention period possible + 24 hours
       • Daily full backup and regular transaction backup are performed
     • Backup time: select the Full backup execution time between automatic and user-defined
     • If you select this, additional fees will be incurred according to the storage capacity used
       • Automatic: backup is automatically started every day
       • User-defined: backup is started every day within 15 minutes from the time you selected
3. Click [Next].
4. When subscribe to Cloud Log Analytics service appears, check the content, and then click [OK].
   • If you need to subscribe to Cloud Log Analytics, click [Subscribe to Cloud Log Analytics]
   • For more information on Cloud Log Analytics, see Cloud Log Analytics user guide

3. Final confirmation

1. When the final confirmation page appears, view the configured server information, DB information, and Backup information.
   
   • Click [Previous] to edit the settings
2. Click [Create].
3. Check the status of the MSSQL Server that was created from the server list on the DB Server page.
   • Creating: status in which the MSSQL Server is being created with the information entered by the user
   • Configuring: status in which the MSSQL Server is being configured after being created with the information entered by the user
   • Running: status in which the creation and configuration of the MSSQL Server have been completed with the information entered by user, and access to MSSQL from the application server is available

Restart MSSQL Server

You can easily and conveniently restart MSSQL Server. You can't access servers while they're being restarted. Follow these steps to select a rebooting schedule reserved and restart it:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. Click the MSSQL Server you want to restart, and then click [Restart DB server].
4. When the OS Reboot pop-up window appears, select how to reboot the server.
   • Without Failover: the user's SSMS configuration content is guaranteed, but the service down time may take several minutes.
   • With Failover: the service down time doesn't exceed 30 seconds, but the user's SSMS configuration content may be lost.
5. Click the [Schedule rebooting] after setting the search period and filtering conditions.
   • Rebooting can be scheduled to be the time when 3 minutes have passed from the point of setting up.
   • If you want to restart the server immediately without scheduling it, click [Reboot now].
6. Check the status of the MSSQL Server from the MSSQL Server list on the DB Server page.
   • Restarting: status in which the MSSQL Server is being restarted
   • Running: status in which access to the MSSQL Server from the application server is available due to the server being rebooted up

Delete MSSQL Server

You can delete an MSSQL Server that has been created and is in operation.

If you're using high availability, then both the Principal Server and Mirror Server will be deleted. If you have Slave Servers, then you need to first delete all Slave Servers from the DB Service before deleting the Principal Server. If you're using the backup function, then the backup files are also deleted.

Follow these steps to delete MSSQL Server:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. Click the MSSQL Server you want to delete, and then click [Delete DB server].
4. When the delete DB server popup window appears, enter the name of the MSSQL Server to delete, and then click [OK].
5. Check the status of the MSSQL Server from the MSSQL Server list on the DB Server page.
   • Deleting: status in which the MSSQL Server is being deleted

MSSQL Server monitoring

NAVER Cloud Platform's Cloud DB for MSSQL provides a monitoring service through the dashboards on each server. This allows users to intuitively check servers in operation and data status and efficiently manage them.

Follow these steps to go to the monitoring page of the MSSQL Server that has been created and is in operation:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. Click the MSSQL Server you want to monitor, and then click the [Monitoring] button.
4. Click and select the dashboard you want to monitor.
   

Manage MSSQL Server

While operating the created MSSQL Server, situations where you need to change the options related to the server or DB configured upon creation may occur. Cloud DB for MSSQL supports change or upgrade of some specifications through a few simple clicks, even for MSSQL Server that has already been created.

Follow these steps to manage the MSSQL Server that has been created and is in operation:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click DB Server.
3. Click the MSSQL Server you want to manage, and then click [Manage DB].
4. Click and select the item you want to manage.
   
   • View DB Server details
   • Change DB specifications
   • Manage DB Config
   • Manage DB User
   • Manage Database
   • Manage Public domain
   • Manage Backup settings
   • Add Slave
   • Adjust time available for reading

View MSSQL Server details

You can check the details related to the server to see if the selected MSSQL Server is running properly. The details are as follows:

Change MSSQL Server specifications

You can change the server specifications for the MSSQL Server you created. When changing the server specifications, the specifications for the Master, Mirror, and Slave Servers are also all changed. Additional fees are incurred for upgrading specifications.

To change the specifications, follow these steps:

1. When the change DB Server specifications popup window appears, view the current server specifications.
2. Click and select the server specifications you want to change to.
   
3. Click [OK].
4. Check the status of the MSSQL Server with the specifications modified from the MSSQL Server list on the DB Server page.
   • Configuring: status in which the MSSQL Server is being configured after being with the information entered by the user
   • Running: status in which the configuration of the MSSQL Server has been completed with the information entered by user, and the access to MSSQL Server from the application server is available

Manage DB Config

You can change Config Group to apply to MSSQL Server you created. The changed Config Group is applied to all servers within the same service group, and some Config variables are applied after an automatic restart of DB Service upon change. The application is available after creating a Config Group. For more information on how to create, edit, and delete Config Groups, see Config Group.

To change it, follow these steps:

1. When the Change DB Config Group window appears, check the Config Group currently applied.
2. Click and select the Config Group to change to.
   
3. Click [Change].
4. Click the MSSQL Server with the changed Config Group from the MSSQL Server list on the DB Server page.
5. Click [Restart required] under Database Config.
6. Check the status of the MSSQL Server from the MSSQL Server list on the DB Server page.
   • Restarting: status in which the MSSQL Server is being restarted
   • Running: status in which access to the MSSQL Server from the application server is available due to the server being rebooted up

Manage DB User

You can change the password of the admin DB account for the MSSQL Server created.

Follow these steps to change the password of an admin account:

1. When the manage DB User pop-up window appears, check the DB admin account.
2. Enter the new password.

• Enter between 8 and 20 characters containing at least 1 English letter, number, and special character
• Special characters ` & ₩ " ' / and spaces can't be used
  

3. Click [Save].

Manage Database

You can add DBs to the selected MSSQL Server or delete them. Up to 3 DBs can be added or deleted at one time.

Follow these steps to add or delete databases:

1. When the manage Database pop-up window appears, check the database information.
2. Add or delete databases.
   
   • Add: enter the database name to add to Database Name and then click the [Add Database] button
     • The ID must be 1-20 characters using English letters, numbers, and the underscore (_)
     • It must start with an English letter
   • Delete: click [Delete] for the created database row
3. Click [Save].

Manage Public domain

You can request a Public domain to allow access to MSSQL Server from outside of NAVER Cloud, or remove the configured Public domain. If you've set up a Public domain, you will be charged for the amount of network usage for the data used for external communication. If you remove the Public domain, access to the DB Server is only available within NAVER Cloud Platform.

The following shows how to set up or remove Public domain:

1. When the request public domain pop-up window appears, check the DB Server's name.
   • If you're to remove the Public domain assigned, the remove Public domain popup window will appear. Check the DB Server name and Public domain.
     
2. Click [Yes].
3. Check the status of the MSSQL Server for which you've set the DB Failover, from the MSSQL Server list on the DB Server page.
   • Configuring: status in which the MSSQL Server is being configured after being with the information entered by the user
   • Running: status in which the configuration of the MSSQL Server has been completed with the information entered by user, and the access to MSSQL Server from the application server is available

Manage Backup settings

You can set the backup file retention period and backup time for the selected MSSQL Server. The backup files can be kept for a minimum of 1 day and a maximum of 30 days. The backup will be performed within 15 minutes of the time selected.

Follow these steps to set up backup retention period and backup time:

1. When the backup retention period (backup time) pop-up window appears, check the backup settings information.
2. Set the backup file retention period and backup time.
   
3. Click [Save].

Add Slave Server

You can add a readable Slave Server to the MSSQL Server using the high availability settings. Private domains are assigned by default to the Slave servers, and Public domains can also be assigned separately. Up to 5 Slave Servers can be added for one Master Server.

The settings of Principal Server are applied identically to its Slave Server.

• MSSQL Server type
• Data storage type
• Data storage capacity
• DB Config settings

The same fees apply to Slave Server as Principal Server, and the fees are charged based on the hours used. To add Slave Server, follow these steps:

1. When the add Slave DB Server pop-up window appears, check the information for the Principal Server and the Slave Server.
   
2. Enter the unique 3-digit number (001-999) for the domain you'd like to use, and click [Check for duplicate domains].
3. Click [OK].
4. Check the status of the Slave Server that was created from the MSSQL Server list on the DB Server page.
   • Creating: status in which the Slave Server is being created with the information you entered
   • Configuring: status in which the Slave Server is being configured after being created with the information you entered
   • Running: status in which the creation and configuration of the Slave Server has been completed with the information entered by user, and the access to the Slave Server from the application server is available

Adjust time available for reading

Slave Servers work with the log shipping method, and they are not available to be used for service directly. You can set it up to be available for reading during a certain time every day to be used for batch jobs, and so on. DB restore won't be carried out during the set time so that it is available for reading. Up to 20-time ranges can be selected as the time available for reading.

To set ACG, follow these steps:

1. When the adjust time available for reading pop-up window appears, check the times set as available for reading.
2. Select the time range you want available for reading, and then click [OK].