If I remember correctly, it stays with the house, not the business.  So if a different business with a home office in the same house is started, the carried over expenses can be used for the new business.

But as you said, if/when the house is sold, it is forever lost.