Dump a database in SQL Server 2005

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Adam Haines SSC-Insane Points: 23217 More actions · Answer 1

If you want to delete a database you can:

USE [master]

GO

DROP DATABASE DATABASE_NAME

GO

if you want to delete backup history you can

USE [master]

GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'DATABASE_NAME'

GO

Adam Haines SSC-Insane Points: 23217 More actions · Answer 2

You can even highlight a database in SSMS and click the delete key.