Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Question Unanswered: how to fire triggers during log shipping

    Hi,
    We are trying to impliment log shipping. During the log shipping the target database will have insert, update or delete trigger on some of it's table.
    Can some one let me know will these trigger get fired during log shipping. if not the is there some way to fire these triggers.

    Thanks,
    manoj

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Triggers on primary database will have no issues while Log shipping process is on, anyway the secondary server database will be in read-only mode so no affect.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    4
    It means these triggers will never fire on secondary database.
    is there any way I can make them fire.

    Thanks

    Originally posted by Satya
    Triggers on primary database will have no issues while Log shipping process is on, anyway the secondary server database will be in read-only mode so no affect.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why do you want fire triggers on secondary database, as LS process will restore the transactions from primary database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jun 2003
    Posts
    4
    Hi satya,

    I need to explain you the scenario

    We have two system with two seperate production database on two physicaly seperate servers. one of the production database is search intensive and the other is transaction intensive. There are few common tables in these two databases.

    As the data in transaction intensive database changes we want to move this data to the search intensive database to keep in sync.

    The client don't want replication as solution.

    client is planning to implement the runtime Log shifting for failover database of Transaction intensive database.

    So we want to take this opportunity to run triggers on this failover database to move data to search database. as this we think will keep the down time to zero.

    any suggestions?

    Regards
    Manoj

    Originally posted by Satya
    Why do you want fire triggers on secondary database, as LS process will restore the transactions from primary database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •