ict.ken.be

 

Drop a database

Related Posts

Categories: SQL Server

 

  1. Stop the sql server within services
  2. Delete the physical files (.mdf , .ldf)
  3. Start the sql server
  4. Right click the offline database and click delete

 

USE MASTER 

GO 
 
ALTER DATABASE Ken_Database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
 
DROP DATABASE Ken_Database
GO