SQL Server Performance

Log Shipping Doubt

Discussion in 'SQL Server 2005 Log Shipping' started by rayala.thulasi, Mar 7, 2010.

  1. rayala.thulasi New Member

    Dear All.
    I have my environment with SQL 2005 Databases and those Databases are configured with LogShipping Configuration.here i want to clarify one doubt related to detaching the Databases. my database has been configured the LS Process and i want to detach my database for some purpose. If Once i detach the DB is All the LS Configuration features will come while attaching the Database or we need to re-configure the Process. Please let me know your views on this.
    rayala.thulasi, Mar 7, 2010
    #2

  2. satya Moderator

    You have to reinstate the LOG SHIPPING process again,a s the DB is detached and attached the system catalog values will be updated.
    LS is a complete manual process and in any case even for DB mirroring or replication if you detach and attach you have to reinstate the process again.
    satya, Mar 24, 2010
    #3

Share This Page