Moving SwSQL Databases to another drive: Difference between revisions
(Created page with "{{Template:Basic Cover |title=Moving SwSQL Databases to another drive |type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |applicableto...") |
No edit summary |
||
| Line 22: | Line 22: | ||
# On the new drive location create a folder to locate the database files (i.e. Z:\SwSQL\data) | # On the new drive location create a folder to locate the database files (i.e. Z:\SwSQL\data) | ||
# Stop the SwSqlServer service and all the Supportworks Services | # Stop the SwSqlServer service and all the Supportworks Services | ||
# Copy all files and folders from the current path: <cs-install-path>\SwSqlServer\data to the new path (i.e. Z:\SwSQL\data) | # Copy all files and folders from the current path: '''<cs-install-path>\SwSqlServer\data''' to the new path (i.e. Z:\SwSQL\data) | ||
# Open the SwSQL.ini file located: <cs-install-path>\SwSqlServer\bin\swsql.ini | # Open the SwSQL.ini file located: '''<cs-install-path>\SwSqlServer\bin\swsql.ini''' | ||
# Modify the line "datadir = C:/Program Files (x86)/Hornbill/Core Services/SwSqlServer/data" to "datadir = Z:\SwSQL\data" | # Modify the line '''"datadir = C:/Program Files (x86)/Hornbill/Core Services/SwSqlServer/data" to "datadir = Z:\SwSQL\data"''' | ||
# Start the SwSQLServer service and All the Supportworks Services | # Start the '''SwSQLServer''' service and All the '''Supportworks Services | ||
# Restart the | ''' | ||
# Restart the '''SwHttpServe'''r service | |||
# Once the server is up and running and the data is intact then remove original data folder | # Once the server is up and running and the data is intact then remove original data folder | ||
Note: | '''Note:''' | ||
You should also consider changing the path of the temporary file location to another location, however the location should be not the same as the data dir: tmpdir = C:/Program Files (x86)/Hornbill/Core Services//SwSqlServer/temp | You should also consider changing the path of the temporary file location to another location, however the location should be not the same as the data dir: '''tmpdir = C:/Program Files (x86)/Hornbill/Core Services//SwSqlServer/temp''' | ||
If you require any further information or assistance in relation to the procedures above, please feel free to contact the Support Team. | If you require any further information or assistance in relation to the procedures above, please feel free to contact the Support Team. | ||
Latest revision as of 13:09, 12 December 2016
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Core Services Version 3.1.x |
Moving SwSQL Databases to another drive
By default the SwSQL database server configures the drive where all databases are stored to be on the same drive as the installation path. However in an environment where there is heavy use of the server this configuration can be highly inefficient. It is good practice to locate the databases on a drive other than that of the OS and other applications this will help to alleviate contention with disk read / writes.
This document first takes you through the steps required to change the path where the SwSQL server will locate database and how to move the databases to configured location
Changing the default location for SwSQL database files
- On the new drive location create a folder to locate the database files (i.e. Z:\SwSQL\data)
- Stop the SwSqlServer service and all the Supportworks Services
- Copy all files and folders from the current path: <cs-install-path>\SwSqlServer\data to the new path (i.e. Z:\SwSQL\data)
- Open the SwSQL.ini file located: <cs-install-path>\SwSqlServer\bin\swsql.ini
- Modify the line "datadir = C:/Program Files (x86)/Hornbill/Core Services/SwSqlServer/data" to "datadir = Z:\SwSQL\data"
- Start the SwSQLServer service and All the Supportworks Services
- Restart the SwHttpServer service
- Once the server is up and running and the data is intact then remove original data folder
Note: You should also consider changing the path of the temporary file location to another location, however the location should be not the same as the data dir: tmpdir = C:/Program Files (x86)/Hornbill/Core Services//SwSqlServer/temp
If you require any further information or assistance in relation to the procedures above, please feel free to contact the Support Team.