SQL Server Performance

Detaching a Publication Database running Transactional Replication

Discussion in 'SQL Server 2005 Replication' started by SQL2, Mar 31, 2008.

  1. SQL2 New Member

    I want to Detach a publisher database running Transactional Replication, then move the .ldf (log files) to a different drive.
    I want to ensure that when i re-attach the database, that Transactional Replication continues running as usual.
    Will detaching the database affect replication?
    I am using SQL Server 2005, and I have ServerA configured as the as the Publisher
    and ServerB configured as the Distributor and Subscriber i am using push subscription
    SQL2, Mar 31, 2008
    #2

  2. Luis Martin Moderator

    Once again.
    You already have an answer in msdn forum.
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3091911&SiteID=1
    Do you thing the answer is wrong?
    Luis Martin, Apr 2, 2008
    #3

  3. MohammedU New Member

    In SQL 2000 it can be done by updating the category column in sysdatabases table to 0 but I have not tested anything in SQL 2005.
    If you want to move only .ldf file then you can add the new .ldf file where ever you want to move then you can run DBCC SHRINKFILE with EMPTYFILE option then delete it.
    MohammedU, Apr 7, 2008
    #4

Share This Page