DS-System Database Installation Recommendations
Summary
It is recommended that the DS-System database data files reside on a different physical device than the log files - and if possible, on a different disk controller (unless using different, more sophisticated integrity strategies, like RAID subsystems, database replication, standby servers, etc). Microsoft's recommendation is: "Do not place the transaction log file or files on the same physical disk with the other files and filegroups".
To do this, you will require three different drives:
This will maximize the performance due to parallel disk I/O. It will also improve the chances of recovering the database to its state at the point of disk failure (in case that disk is damaged).
DS-System is configured to perform a full database backup every day. In case of a hard disk failure (either the disk holding the data or the disk holding the log files) there are 2 scenarios:
If the disk holding the log files fails:
1. Perform a full backup of the DS-System database (data files) immediately.
If the disk holding the data files fails:
The database could be restored to the state it was at the point of failure if the current transaction log file for the database is available and undamaged. To restore the database as it was at the point of failure:
1. Back up the current active transaction log.
3. Restore the most recent backup of DS-System database WITHOUT recovering the database.
4. If you perform other backups between two consecutive daily backups, perform the following steps:
- If differential backups exist, restore the most recent one.
- Restore each transaction log backup created since the database or differential backup in the same sequence in which they were created WITHOUT recovering the database.
5. Apply the most recent log backup (created in Step 1), and recover the database.
DS-System Database Installation Script (Data and Log directories)
Before running the DS-System installation (either a fresh installation or an upgrade), it is recommended to reset the Default Data Directory and the Default Log Directory to a different path on different physical drives as specified above. This can be done using SQL Enterprise Manager: select the SQL Server or Instance where the DS-System database will be installed > Right-click > Properties > Database Settings tab.
If you are upgrading a DS-System, you may need to migrate the existing data and log files to their new default locations.
- Note: The same recommendations are valid for DS-Client installation, when using MS SQL Server database or MSDE.
The information provided in this document is provided "AS IS", without warranty of any kind. ASIGRA Inc. (ASIGRA) disclaims all warranties, either express or implied. In no event shall ASIGRA or its business partners be liable for any damages whatsoever, including direct, indirect, incidental, consequential, loss of business profits or special damages, even if ASIGRA or its business partners have been advised of the possibility of such damages. © Asigra Inc. All Rights Reserved. Confidential.
![]() ![]() |