How to delete data or log files from a database (Enterprise Manager)
SQL Server 2000
To delete data or log files from a database
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database from which to delete the data or log files, and then click Properties.
- To delete data files, click the General tab. To delete log files, click the Transaction Log tab.
- In the File name column, click the arrow next to the name of the file to delete, and then press the DELETE key. A cross will appear next to the file name indicating that the file will be deleted.
Note Files can be deleted only if they are empty. Remove all objects on the files and shrink the database before deleting files from the database.