Change file location and log location for distribution database RRS feed

  • Question

  • hi there:

      We have a snapshot replication running in production and going to deploy a transactional replication to production.  We've discovered that our distribution database currently sits in drives that are too tight for both files and log for distribution database.

    We  plan to add more files to distribution database. Will this operation have any impact on the existing snapshot replications? 



    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Wednesday, February 17, 2016 11:47 PM


  • No, that should be fine. Or you can simply stop all the related jobs, move the DB to another drive that have more space, then start it off again. SQL server does really care where the location of the files as long as it got access to the DB (not related to performance etc).

    • Proposed as answer by Charlie Liao Tuesday, February 23, 2016 6:48 AM
    • Marked as answer by Charlie Liao Monday, March 7, 2016 2:00 AM
    Thursday, February 18, 2016 3:14 AM