如何在企业版中附加sql server 2008 Express Edition数据库 [英] how to attach database of sql server 2008 express edition in enterprise edition

问题描述

大家好.

我上周在sql server 2008 Express Edition中开发了一个数据库.
我想在sql server 2008企业版中打开此数据库，但是当我使用数据库附加选项或管理选项时，无法附加数据库.

我收到错误消息

标题:Microsoft SQL Server Management Studio
------------------------------

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

------------------------------
按钮:

OK
------------------------------
"

请帮帮我.

预先感谢.

Hi everyone.

I have developed a database in sql server 2008 express edition last week.
I want to open this database in sql server 2008 enterprise edition, but when I use Database attach option or Management option I can''t attach database.

I get the error message

"TITLE: Microsoft SQL Server Management Studio
------------------------------

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

------------------------------
BUTTONS:

OK
------------------------------
"

Please help me.

Thanks in advance.

推荐答案

我认为服务器名称必须是[您的计算机名称] \ SQLEXPRESS，但是在安装时我选择的实例是HUYQPC.
我尝试测试，但不能确定.
请帮助我.谢谢

I think sever name must is [your machine name]\SQLEXPRESS but when setup I chose instance is HUYQPC .
I try test but not Ok .
please help me .Thanks you

我认为SQL Express设置了与企业版不同的服务器实例.尝试寻找名为SQLEXPRESS \ [您的机器名称]的服务器

I think SQL Express sets up a server instance separate from your Enterprise edition. Try looking for a server named SQLEXPRESS\[your machine name]

这篇关于如何在企业版中附加sql server 2008 Express Edition数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！