Database disappear in prod and rolled back 3 months ago in dev

Maybe this video will help:

but your actually need just to switch to the remote target and then reapply the database changes there.