Unanswered: Triggers Firing During Database Loads?
I came across this in Sybooks and was bemused:
Loading a database from a previous dump causes any triggers defined in the database to fire, which can increase the amount of time required to load the database. Use the disable trigger option of the alter table command to disable any triggers in a database before you load the database. Use the enable triggers clause to re-enable the triggers after the load database is complete.
Any ideas why Triggers are fired? I thought the database loads blatted all the data pages anyhow.