October 2, 2010 at 7:30 am
I have Transactional Replication running between 2 DBs on the same server, Publisher,Subscriber and Distributor are on the same server. We are moving all our DBs to a new and faster SAN, including the 2, I am replicating.
Which is the best way to move them without disrupting replication or having to take it down and recreate it ? How can I move the Distribution DB?
Thanks,
October 2, 2010 at 8:10 am
Are you moving the DBs to another location on the same server or to different servers?
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/27/how-to-move-publication-database-and-distribution-database-to-a-different-location.aspx talks about how to move the distribution (and publication DB) to a new location within the same server. The link is SQL 2008 specific and I've never tried these steps out on a SQL 2005 replication setup (but I think it should work).
October 2, 2010 at 1:41 pm
Same server.
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply