water storage has always been buggy for me at sanctuary
has worked perfectly fine everywhere else but for example in latest game i had an industrial and medium water purifier, this was netting me 26-36ish waters a day
was working fine untill one day it just stopped, i wasnt getting a single water in my workbench (this has happened in my other 2 characters at sanctuary too, all of a sudden just stops). went around a game month without a single water being stored.
all my settlements regardless of supply line or not have an overabundance of water resource, i always build over and above water requirements (and nets me decent monies that way too)
i tried storing them and re-placing them. that didnt work
i tried scrapping them and rebuilding. also didnt work
but then i seeded the workbench with a single bottle of purified water. Now they work normally again and am getting my water supplies each day as normal.
it may of been a combination of what i did or it could be a coincidence, but try placing a single purified water in your workbench in sanctuary and see if they start producing again?
8 bottles in red rocket is nothing, i doubt its getting the water from sanctuary that will just be its own output (you have water pumps there?)
everyone of my settlements produces its own output into its own workbench.
edit: oh and just incase you dont know. the water producers dont "add" water persay to the workbench, they over-write it
eg if you had 30 water in there and the next day they make another 29, you wont have 59 in there you will have 29.
found that out the hard way on my first character, i was storing everything in workbench and then realized the 100 or more that id found out in the world was all gone being replaced over and over by 20 waters or so. also food, bastards ate all my prewar food. fat gits