How to move the files of a replicated database (SQL Server 2008 R2) to a different drive
- by ileon
I would appreciate if someone could help me with the following problem:
We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable subscriptions. because we run out of disk space we need to move the database files into a new drive. But I don't want to break the replication.
What I'm looking for are the required steps that will help me to move the files to the new drive.
Thanks