Moving SQL Server2005 Replicated Database

  • My hard disk is running low on free space I want to move my replicated database from this Disk to a new hard disk without losing the replication settings is it possible? or do i have to start the replication process all over again?

  • Can you stop replication, add a new drive with more space and then swap the drive letters between drives? For example, if your replicated database is located on drive D: and you add Drive E: after copying everything from D to E, rename D to E and E to D. We just did this because an application was running out of space, and after the database was brought back up it continued to work without issues. Haven't tried it with replication though.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply