locked
How to bypass ' database "distribution" cannot be opened due to inaccessible files or insufficient memory or disk space ' error RRS feed

  • Question

  • Hi all,

    On one of the SQL server machines, we took out a disk drive that was hosting the distribution database for transactional replication. We then provided a new empty disk drive to the SQL server. Now we are trying to disable the Publishing and Distribution thru SSMS but it failed due to " database "distribution" cannot be opened due to inaccessible files or insufficient memeory or disk space " error. Is there a way to bypass this and clean up the distribution/publication in a forceful way? 

    Long story short, disk hosting distribution database got replaced. Now not able to disable distribution/publication thru SSMS. 

    Thank you

    Wednesday, July 3, 2019 4:17 PM

All replies