I created a copy of an existing database, then migrated the database to V12 for testing.
Example:
originalDb was copied to originalDb-copy
originalDb-copy was migrated to V12
originalDb deleted
originalDb-copy renamed to originalDb.
logging into the server without specifying a database the sys.databases contains: "master" and "originalDb-copy" but nothing can be done with "originalDb-copy" (cannot delete it and it contains no tables)
If I log into the server specifying "originalDb" then sys.databases contains: "master" and "orginalDb".
originalDb and originalDb-copy have different database_id's.
How do I clean up this mess?
- Moved by Shirisha PaderuMicrosoft contingent staff, Moderator Saturday, August 01, 2015 12:07 PM azure sql Database renaming