如何将SQL Server 2000中的.BAK文件附加到sqlserver 2014中。 [英] How to attach .BAK file 0f SQL server 2000 into sqlserver 2014.

问题描述

I have Sql Server 2000 .BAK File (Database record ) now, i need to attach the .BAK file in Sql Server 2014  it is Possible? Otherwise, how to get that record ..

什么我试过了：



我现在有Sql Server 2000 .BAK文件（数据库记录），我需要在Sql Server 2014中附加.BAK文件有可能的？否则，如何获取该记录..

What I have tried:

I have Sql Server 2000 .BAK File (Database record ) now, i need to attach the .BAK file in Sql Server 2014 it is Possible? Otherwise, how to get that record ..

推荐答案

您不能将.bak文件附加到实例; .bak文件是SQL备份，因此您必须从.bak文件恢复到您的实例。



请参阅使用SSMS恢复数据库备份 [ ^ ]

You cannot "attach a .bak file" to an instance ; .bak files are SQL backups, thus you have to restore from the .bak file to your instance.

Please see Restore a Database Backup Using SSMS[^]

这篇关于如何将SQL Server 2000中的.BAK文件附加到sqlserver 2014中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！