Home » Categories » Solutions by Business Process » SQL

Suspend SQL Mirroring During Night / Weekends

Datafile Software

Suspend SQL Mirroring During Night / Weekends

The SQLMGR program, once started, reads the SQLDET database continually for new records to process and can mean – when your business operates on a set opening times basis – that the SQLMGR is interrogating the database when no changes are being made.

New options are now available that can be added to the PARAM.INI (a file held within the main Datafile SQL program folder which can be edited with any text editor) to exclude mirroring during set days/times.


Commands to add are:

exclude=19:30-08:30

exclude_day=Sat,Sun

If you have a night time process that you need to mirror then you can set multiple times for exclusion, for example, you have an offsite import that is processed at midnight then you could have an ‘exclude’ entry along the lines of:

Exclude=19:30-23:30,01:00-08:30

Custom Fields
  • Release ID: 6.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
SQLDET Database Structure
Viewed 4432 times since Mon, Jun 11, 2012
Database Refresh - Empty Table and Re-Import Data
Viewed 2368 times since Mon, Jun 11, 2012
Update Individual Records to SQL on Nominal Update
Viewed 2728 times since Fri, Oct 26, 2012
SQL In
Viewed 2066 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4355 times since Fri, Jul 21, 2017
Additional SQLDET.DFD Maintenance Options
Viewed 9939 times since Mon, Jun 11, 2012
Datafile SQL Monitor
Viewed 2207 times since Thu, Jul 5, 2012
Installing the Datafile SQL Driver
Viewed 2708 times since Thu, Jul 5, 2012
Running the SQL Manager
Viewed 2340 times since Thu, Jul 5, 2012
Datafile SQL Configuration
Viewed 1970 times since Thu, Jul 5, 2012