在2008年附加SQL Server 2000 db

I have MDF file of SQL Server 2000 and I dont have 2000 but visual studio 2008 i want to attach this mdf to my studio 2008 how can I do that. Thanks

我有SQL Server 2000的MDF文件,我没有2000但是visual studio 2008我想将这个mdf附加到我的工作室2008我该怎么做。谢谢

1 个解决方案

#1

OK - you should be able to attach the SQL Server 2000 database to SQL Server 2008. You can do this through the SQL Server Management Studio interface or via a script against the 2008 server.

确定 - 您应该能够将SQL Server 2000数据库附加到SQL Server 2008.您可以通过SQL Server Management Studio界面或通过针对2008服务器的脚本执行此操作。

USE master;
GO
CREATE DATABASE db ON PRIMARY 
   (FILENAME = 
      'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\db.mdf')
   LOG ON (FILENAME = 
      'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\db_log.ldf')
   FOR ATTACH;
GO

Substitute your database name and file paths. When you do the attach, the database will be upgraded to a SQL Server 2008 database, but will remain in SQL 2000 Compatibility mode.

替换您的数据库名称和文件路径。执行附加时,数据库将升级到SQL Server 2008数据库,但仍将保持SQL 2000兼容模式。

Here's a link with more info: http://msdn.microsoft.com/en-us/library/ms189625.aspx

这是一个更多信息的链接:http://msdn.microsoft.com/en-us/library/ms189625.aspx

#1