Menu
In the sql server database list here:
https://manage.windowsazure.com/#Workspaces/SqlAzureExtension/Databases
I select a database and at the bottom is "Delete".
I press delete and it processes a little while then says:
Could not delete database 'system-50e5f905-...etc'
I follow a link for more details where it just says:
Bad Request
Extra info
They do not appear to be linked resources anywhere.
I have been able to create and delete a new database.
I have also connected using MS SQL server management studio and I can only see two named databases, none of the databases that have a name format of system-guid for a name.
941
To remove a database from the current server without deleting the files from the file system, use sp_detach_db. USE master; ALTER DATABASE [databasename] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE [databasename] ; Note, database backups will not be deleted as part of the process documented above.
To delete a databaseExpand Databases, right-click the database to delete, and then click Delete. Confirm the correct database is selected, and then click OK.
If you want to delete a server there are a couple of options. One simple way is to use the Remove-AzureSQLDatabaseServer PowerShell cmdlet. The following is an example: Remove-AzureSQLDatabaseServer -ServerName 'MY SERVER NAME' Just replace 'MY SERVER NAME' with the name of the server you want to delete.
Databases with the name format system-SOME GUID may be federations.
Deletion (Dropping) of a federation must be done within the database Management Portal for the main database.
Caution: I don't know the ramifications of dropping a federation, so make sure you have backups of data you don't want to loose or research this further.
184
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
