Make triggers inactive for other databases

[memcom]

We use a number of triggers in our production database. We frequently have to create a backup of our production database and restore it to a testing database on the same server with a different name. The problem I have, is that a number of the triggers are for email notification and I do not want those triggers to be active on the testing database. Other triggers are needed however. What is the best way to disable some triggers on the testing database? Is it possible to add a line to the trigger to only run if the current database is a given name? or do I need to setup a script to run that will delete triggers that are a given name?

 

[eramgarden]

This is the general command :

ALTER TABLE table_name

DISABLE TRIGGER trigger_name --or ALL, which disables all triggers