应用程序可以在没有日志文件的情况下打开 .mdf 但 Management Studio 无法附加 [英] Application can open .mdf with no log file but Management Studio can not attach

问题描述

我安装了 DevExpress 演示

I installed the DevExpress demo

C:\Users\Public\Documents\DevExpress Demos 15.2\DevExtreme\DXHotels

该演示随附在 App_Data 文件夹中的 HotelDB.mdf.

The demo came with HotelDB.mdf in the App_Data folder.

出于好奇，我试图通过尝试使用 SQL Server 2012 Express Management Studio 附加它来打开 HotelDB.mdf

Out of curiosity I attempted to open the HotelDB.mdf by attempting to attach it using SQL Server 2012 Express Management Studio

但是，我在执行此操作时收到有关丢失日志文件的错误.

However I got an error about a missing log file when I did this.

当我从解决方案中运行应用程序时，会创建日志文件，随后我可以使用 SQL Server 进行附加.

When I ran the application from the solution the log file created and I was able to subsequently attach using SQL Server.

为什么应用程序可以打开文件而 Management Studio 不能打开?

Why was the application able to open the file when Management Studio could not?

推荐答案

尝试以下方法之一......

Try one of the following ......

CREATE DATABASE HotelDB
ON (FILENAME = N'C:\App_Data\HotelDB.mdf')  --<-- The path to your .mdf
FOR ATTACH_REBUILD_LOG
GO

或

CREATE DATABASE HotelDB
ON  (FILENAME = N'C:\App_Data\HotelDB.mdf')  --<-- The path to your .mdf
FOR ATTACH
GO

这篇关于应用程序可以在没有日志文件的情况下打开 .mdf 但 Management Studio 无法附加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！