删除数据库后无法删除LDF [SQL Server 2012 Enterprise x64] [英] Unable to delete LDF after deleting database [SQL Server 2012 Enterprise x64]

问题描述

使用SSMS删除数据库后，我可以删除MDF文件，但无法删除LDF文件。输出来自...

After deleting my database using SSMS I am able to delete the MDF file but cannot delete the LDF file. The output from ...

SELECT *FROM sys.master_files

...包含有问题的文件。



如果不重新启动SQL Server，如何释放LDF文件上的文件锁？

... includes the file in question.

Without restarting SQL Server how do I release the file lock on the LDF file?

推荐答案

我怀疑有问题的文件属于另一个数据库，而不是你丢弃的数据库。

I would suspect that the file in question belongs to another database than the one you dropped.

这篇关于删除数据库后无法删除LDF [SQL Server 2012 Enterprise x64]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！