Detaching subscription database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Detaching subscription database

hi all
I have a question about replication.
I have a transactional replicatoin and merge replication going across interent to one of our subscribers in Ireland.
now, the subscribers server DBA want to increase some space on the server.
but before that he wants to stop replication for a moment, backup the subscription database and restore it as a new database.
will starting replication is going to work on a new restored database withouth repushing the whole snapshot again(bcoz thats going to take 3 days)
I am concerned specially with the merge replication.
My idead was to stop the replication on the distribution srever. and detach the database on the subscriber server. Increase the space and attach the
subscription databse back. I have tested this with a transactional replication and it is working.
do you guys have other suggestions for this.
Thanks in advance.

It should work, provided you are not changing the restored/re-attached database name. there should not be any problem

Thanks, madhu


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |