且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将数据库附加到SQL Server管理

更新时间:2022-11-24 20:00:53

尝试备份和还原数据库,而不是附加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