附加.mdf文件 [英] To attach the .mdf file

问题描述

我在特定位置(D:\ DBFolder)中有Test.mdf和Test.ldf文件

但是当我通过附接选项附加该Test.mdf文件时，则显示错误消息(``服务器''MachineName \ SQLEXPRESS''的附加数据库失败.
(Microsoft.SqlServer.Express.Smo)'')

我的数据库userID = sa
我的数据库密码= sa
数据库服务(``SQL Server(SQLEXPRESS)'')登录为``NT AUTHORITY \ NETWORKSERVICE''

我的操作系统是XP serpack 2，并且未设置密码，并且操作系统系统用户名是"Machine \ User"

我该如何解决以上问题??????
请任何指示帮助我....

I have the Test.mdf & Test.ldf files in my particular location(D:\DBFolder)

But when I attach that Test.mdf file by attach option then a error msg shown(''Attach database failed for Server ''MachineName\SQLEXPRESS''.
(Microsoft.SqlServer.Express.Smo)'')

my database userID = sa
my database Password = sa
The Database Service (''SQL Server (SQLEXPRESS)'') logon is ''NT AUTHORITY\NETWORKSERVICE''

My OS is XP serpack 2 & No set password & OS System UserName is ''Machine\User''

How will i solve above problem?????
Please Please help me any instruction.......

推荐答案

可能没有.数据库附件失败的原因的说明
喜欢

there could be no. of reasons for failure of database attachment
Like

1. mdf file is made in upgrated virsion than your sql server's version
   e.g. database was created in 2008 and you are trying to attach in sql-2005
2. Login 'sa' have not enough rights/permissions to perform database attachment.
3. this Name is already exist in history of database names.

等...

如果可能，请描述错误的详细信息.

祝您编码愉快！
:)

etc...

please describe error details if it is possible.

Happy Coding!
:)

首先，您需要停止服务器，然后附加文件.

first you need to stop the server then attach the files.

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