Search code examples
sql-server-2008drop-database

How do I drop SQL Databases? sp_delete_database_backuphistory woes


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?


Solution

  • do you get the same problem when executing it from a query window like this?

    DROP DATABASE DatabaseName