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.
|
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4229 times since Fri, Jul 21, 2017
Datafile SQL Driver
Viewed 2266 times since Thu, Jul 5, 2012
Update Individual Records to SQL on Nominal Update
Viewed 2651 times since Fri, Oct 26, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 9213 times since Mon, Jun 11, 2012
SQLDET Database Structure
Viewed 4321 times since Mon, Jun 11, 2012
SQL In
Viewed 1980 times since Thu, Jul 5, 2012
Datafile SQL Configuration
Viewed 1892 times since Thu, Jul 5, 2012
Running the SQL Manager
Viewed 2241 times since Thu, Jul 5, 2012
SQL Out
Viewed 2097 times since Thu, Jul 5, 2012
Configuring the Datafile System
Viewed 2078 times since Thu, Jul 5, 2012
|