Home Forums SQL Server 7,2000 Replication Is detaching and again Attaching a Database will affect the Replication RE: Is detaching and again Attaching a Database will affect the Replication

  • you don't need to detach\attach the database to shrink it.

    you can backup and restore the database without affecting replication as long as replication is quiesced (stop all the replication agents)

    ---------------------------------------------------------------------