The only problem I’m having is that when I try to get to CMS > Manage Pages from the Admin Panel I receive a 404 error.
Found a solution for this that works in my scenario. Take a peak in your `cms_page_store` SQL table. You’ll more than likely see one or more entries there for stores that no longer exist. In my case, I had a page_id of 2 (Home Page) that had entries for store id 1, 2 and 3. Since I deleted stores with ID of 2 and 3, those cms_page_store relations were no longer valid.
I simply removed the two offending entries from this table and now CMS/Manage Pages works properly in the admin.
Not sure if there are any other references to these now missing stores anywhere else in the database, but I can only imagine they would be dealt with in a similar manner.
Seems like those relations should be toasted automagically when the store view is deleted via ‘Manage Stores’??