Question

I recently installed MS SQL Server 2012. I thought it would be a great database software. But after 2 days trail, I found it is not that good as what I thought.

As you can see, every time when I run my project from VS 2010, VS always complains of the .ldf file is being used by another process.(which is the SQL Server 2012) And then I have to disable the SQL Server service from the Service in the Computer Management, so the program can be compiled successfully.

But when the project is running, it requires the SQL Server service running, as some code needs to get access to the database and modify data. Then I have to enable the SQL service.

It s really annoying. It didn t perform like this when I was using SQL Server 2008.

那么，有什么可能的解决方案吗？

我确实尝试在web.config文件中添加配置片段。

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <system.web>
    <hostingEnvironment shadowCopyBinAssemblies="false"/>
  </system.web>
</configuration>

And then I clean the whole solution and rebuild the whole solution, errors remain.

我非常期待尽快看到解决方案。

Answer 1

Probably your solution contains a reference to the LDF file.
And by mistake the Copy to the Output directory is flagged as Copy always or Copy if Newer.

当然，SQL Server经常使用LDF文件（日志文件），因此在编译时会出现所描述的错误。

您不需要引用此文件，因此可以从标记的解决方案中删除Copy Never。

友情链接