Delete data or log files from a database
This topic describes how to delete data or log files in SQL Server by using SQL Server Management Studio or Transact-SQL.
This topic describes how to delete data or log files in SQL Server by using SQL Server
Management Studio or Transact-SQL.
Security
Management Studio
Transact-SQL
A file must be empty before it can be deleted. For more information, see
Shrink a File.
Requires ALTER permission on the database.
- In
, connect to an instance of the SQL Server Database Engine and then
expand that instance.