Home » Categories » Solutions by Business Process » SQL |
Suspend SQL Mirroring During Night / Weekends |
Article Number: 1935 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 2:42 PM
|
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 |
Attachments
![]() There are no attachments for this article.
|
Installing the Datafile SQL Driver
Viewed 3614 times since Thu, Jul 5, 2012
Datafile SQL Monitor
Viewed 2973 times since Thu, Jul 5, 2012
SQL Out
Viewed 2928 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 5627 times since Fri, Jul 21, 2017
SQLDET Database Structure
Viewed 5195 times since Mon, Jun 11, 2012
Datafile SQL Driver
Viewed 3140 times since Thu, Jul 5, 2012
Running the SQL Manager
Viewed 3072 times since Thu, Jul 5, 2012
Datafile SQL Configuration
Viewed 2687 times since Thu, Jul 5, 2012
SQL In
Viewed 2809 times since Thu, Jul 5, 2012
Update Individual Records to SQL on Nominal Update
Viewed 3476 times since Fri, Oct 26, 2012
|