Originally Posted by
TheMadBrewer
Brauerei Fässla has a hotel with 30+ rooms. Brauerei Spezial across the street has rooms, but only 7 and they tend to fill up quickly.
Those two are also recommended in this
article by the New York Times (the Bamberg part starts on page 2). There are also more recommendations available
here.