Can't delete a SQL Database?

Posted by rlb.usa on Server Fault See other posts from Server Fault or by rlb.usa
Published on 2010-05-24T16:59:58Z Indexed on 2010/05/24 17:02 UTC
Read the original article Hit count: 562

Filed under:

ms-sql-2008

|

drop-database

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?

© Server Fault or respective owner

Related posts about ms-sql-2008

T-SQL Improvements And Data Types in ms sql 2008

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Microsoft SQL Server 2008 is a new version released in the first half of 2008 introducing new properties and capabilities to SQL Server product family. All these new and enhanced capabilities can be defined as the classic words like secure, reliable, scalable and manageable. SQL Server 2008… >>> More
Creating an ASP.NET Database using MS SQL 2008 in Visual Web Developer 2008

as seen on ASP Free - Search for 'ASP Free'
This article illustrates how to create a database in ASP.NET. We ll be using Microsoft SQL Server 2 8 and developing it in Visual Web Developer Express 2 8. Given the importance of databases to most websites nowadays you should find this information useful when building just about any website… >>> More
MS SQL 2008, join or no join?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just a small question regarding joins. I have a table with around 30 fields and i was thinking about making a second table to store 10 of those fields. Then i would just join them in with the main data. The 10 fields that i was planning to store in a second table does not get queried directly, it's… >>> More
sp_send_dbmail - MS SQL 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
sp_send_dbmail works fine on one server as below: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'xxxx Mail Profile', @recipients = 'xxx.com', @body = 'xxxxxxxx', @subject = 'xxx - Please do not reply to this email'; But on other server where got same Mail profile setup throws an error saying it… >>> More
MS SQL 2008 HowTo read from log

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi ! I have a table with many rows, is there any way to find out when a concrete row has been inserted? (I don't have create/update time columns) Thanks >>> More

Related posts about drop-database

Drop database on DB2 9.5 - SQL1035N The database is currently in use

as seen on Server Fault - Search for 'Server Fault'
I've never got this working the first time, but now I can't seem to do i at all. There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there are no connection to the database when I… >>> More
Drop database on DB2 9.5 - SQL1035N The database is currently in use

as seen on Server Fault - Search for 'Server Fault'
I've never got this working the first time, but now I can't seem to do i at all. There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there are no connection to the database when I… >>> More
MySQL, undo drop database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys. I've accidentally dropped a database inside my server . I have no backup of it and binary logs are not enabled (shame on me!) ... Is there any way to restore that db? >>> More
Can't delete a SQL Database?

as seen on Server Fault - Search for 'Server Fault'
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:… >>> More
SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use

as seen on SQL Authority - Search for 'SQL Authority'
I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for demonstrations purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error. Msg 3702, Level 16,… >>> More