Wednesday, March 7, 2012

Move distribution database to another drive?

Is it possible to move a distribution database to another drive without removing replication? I have done some research but I getting mixed answers from Google searches.

Thanks in advance

Dave

I don't know the specifics, but I believe it involves creating a new "data file" on the new drive, then telling SQL Server to decommission the original, moving data to the new file as it goes.

-Ryan / Kardax

|||

Have you tried looking in Books Online before google pages?

ALTER DATABASE...MODIFY FILE should work.

No comments:

Post a Comment