SQL Server Performance

LOG SHIPPING & TABLES

Discussion in 'SQL Server Log Shipping' started by duhaas, Sep 16, 2004.

  1. duhaas New Member

    Does log shipping not track new tables? Reason I ask, is I can get log shipping up and running, it copies and restores the log files, but if I make create a table and wait for the log to get created and copied over, i never see the new table on the secondary server.
  2. satya Moderator

    It should be handled with the Transaction log, if any changes occured in Primary server's database should be promoted to Secondary server database with Log shipping.

    Can monitor the events using PROFILER for instance and try to restore full database from Primary server to the secondary server for database sync.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page