Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carloarango
Starting Member
15 Posts |
 Posted - 2010-10-02 : 09:32:26
|
| 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, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-02 : 11:32:03
|
| Use ALTER DATABASE MODIFY FILE.See here: http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/27/how-to-move-publication-database-and-distribution-database-to-a-different-location.aspx |
 |
|
|
|
|
|
Moving Distribution DB and Replicated DBs to a new