How do I drop SQL Databases? sp_delete_database_backuphistory woes

rlb.usa picture rlb.usa · May 24, 2010 · Viewed 16.6k times · Source

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

baazi shaik picture baazi shaik · Nov 10, 2015

enter image description here

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