将数据库附加到SQL Server管理 [英] Attaching Database to sql server management

问题描述

我使用Management Studio 2008创建了mdf数据库，但
在其他系统中，我安装sql server 2008 R2
并通过Management Studio 2008 R2附加文件
出现错误消息，表明不支持版本

该服务器支持655及更早版本.

I created a mdf databse with management studio 2008 but
in other system i install sql server 2008 R2
and by attaching file via management studio 2008 R2
error message appear that show dont support version

this server supports 655 and earlier.


how to attach this file?

推荐答案

尝试备份和还原数据库，而不是附加MDF文件.
此外，除非您运行以下命令，否则SQL Server MDF文件可能不向后兼容:

Try backing up and restoring the database instead of attaching the MDF file.

Also SQL server MDF files might not be backward compatible unless you have run the following :

----SQL Server 2005 database compatible level to SQL Server 2000
EXEC sp_dbcmptlevel dbname, 80;
GO
----SQL Server 2000 database compatible level to SQL Server 2005
EXEC sp_dbcmptlevel dbname, 90;
GO

这篇关于将数据库附加到SQL Server管理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！