2012 年的 SQL Server 2005 mdf 文件 [英] SQL Server 2005 mdf file on 2012

问题描述

我有一个需要安装在服务器上的 SQL Server 2005 .mdf 文件.我可以简单地安装 SQL Server 2012 Express 并附加 .mdf 文件而没有任何问题，还是应该坚持使用 2005 Express 以消除可能出现的任何问题?

I have a SQL Server 2005 .mdf file I need to install on a server. Can I simply install SQL Server 2012 Express and attach the .mdf file without any issues, or should I stick to 2005 Express to eliminate any issues that may arise?

我还应该添加它需要支持 ASP.NET 3.5 网站.

I should also add it needs to support a ASP.NET 3.5 website.

干杯

推荐答案

如果您拥有所有文件(mdf、ldf 和可能的多个 ndf)并且数据库已完全关闭，那么您将不会遇到与 2012 相关的问题.

If you have all files (mdf, ldf and potentially multiple ndf) and the database was cleanly shut down, you won't have an issue attaching to 2012.

如果您只有 mdf，它可能会工作，但也可能会失败.

If you have only the mdf it might work but it could also fail.

无论哪种方式，首先备份您拥有的文件.

Either way, first take a backup of the files you have.

话虽如此，请确保您不使用任何在 2005 年和 2012 年之间发生变化的功能(请参阅 http://technet.microsoft.com/en-us/library/ms143532.aspx 了解详情)

That being said, make sure you don't use any features that changed between 2005 and 2012 (see http://technet.microsoft.com/en-us/library/ms143532.aspx for details)

这篇关于2012 年的 SQL Server 2005 mdf 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！