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