How do I drop SQL Databases? sp_delete_database_backuphistory woes

Question

I want to delete some SQL Databases on my server, but I'm having problems. My login has the roles:

• public
• dbcreator
• serveradmin

When I right click the database and hit Delete, it says that

Delete backup history failed for server 'MYSERVER' (Microsoft.SqlServer.Smo)
Additional Information: The EXECUTE permission was denied on the object 'sp_delete_database_backuphistory'

How do I delete these databases?

Answer 1

Please uncheck the "Delete Backup and restore history information for databases" then click the OK button.