Suspend SQL Mirroring During Night / Weekends
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
- Release ID: 6.6