如何附加.mdf文件sql server 2008？ [英] How to attach .mdf file sql server 2008 ?

问题描述

发生以下错误

1.要升级全文目录，请单击添加目录，然后找到并选择它。将根据全文升级选项导入全文索引。



2.对话框显示错误消息



1.IF您确定已添加所有必要的全文目录，单击确定。要添加更多目录，请单击取消

2.附加数据库时发生错误。单击消息列中的超链接以获取详细信息。



请帮我删除此错误。



谢谢。

解决方案

这两个资源可以帮到你

http://msdn.microsoft.com/en-us/library/ms177429%28v=sql.100%29.aspx [ ^ ]

http： //blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ [ ^ ]

< blockquote>您可以使用以下代码将mdf文件附加到SQL Server：

  CREATE   DATABASE  TestDb  ON  
（FILENAME = @ '  C：\ MyFolder \ TestDb.mdf'）
  FOR  ATTACH 
  GO  

在提及您的问题时，建议删除现有的全文目录并添加具有相同名称的新目录。将服务器实例升级到SQL Server 2008 R2时，用户界面允许您选择三个升级选项：导入，重建和重置。

请参阅以下链接：



http://www.kodyaz.com /articles/sql-server-attach-database-mdf-file.aspx [ ^ ]



http://msdn.microsoft.com/en-us/library/ms165673.aspx [ ^ ]

For following error occur
1. To upgrade a full-text catalog,click add catalog,and locate and select it. Full-text indexes will be imported, based on the Full-Text Upgrade Option.

2. Dialog box show error message

1.IF you are certain that you have added all the necessary full-text catalogs, click ok. To add more catalogs, click cancel
2. An error occured when attaching the database(s). Click the hyperlink in the message column for details.

please help me remove this error occurs.

thank you.

解决方案

These two resources could help you
http://msdn.microsoft.com/en-us/library/ms177429%28v=sql.100%29.aspx[^]
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/[^]

You can attach mdf file to SQL Server using the below code:

CREATE DATABASE TestDb ON
( FILENAME = @'C:\MyFolder\TestDb.mdf')
FOR ATTACH
GO

In reference to your question, itz advisable to remove the existing full text catalog and adding a new catalog with the same name. When upgrading a server instance to SQL Server 2008 R2, the user interface allows you to choose three upgrade options: Import, Rebuild and Reset.

Refer these links:

http://www.kodyaz.com/articles/sql-server-attach-database-mdf-file.aspx[^]

http://msdn.microsoft.com/en-us/library/ms165673.aspx[^]

这篇关于如何附加.mdf文件sql server 2008？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！