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

This issue was resolved offline.

There is a difference between sys.databases on SQL Azure from sys.databases on SQL Server.

In SQL Azure, sys.database is only up to date on the master. As a result, you will need to connect directly to the master database to see all databases on a server. If you connect directly to a non-master DB then sys.database will only show that database and the master.

The full documentation can be found at https://msdn.microsoft.com/en-us/library/azure/ee336235.aspx

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Friday, August 14, 2015 3:43 PM
• Marked as answer by Mark Fox Friday, August 14, 2015 4:03 PM