附加SQL Server数据库

本文介绍了附加SQL Server数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我更改了SQL Server选项，因此更改了特定的数据库 是默认数据库，前几天我出于某种原因分离了数据库 并且知道我无法连接到我的SQL Server，因为它的 寻找我发货的那个特定的数据库. 当我在SQL Server Management Studio中按下连接按钮时 它给了我这个错误:并且没有连接

连接 连接到 服务器 不能 连接 连接到 BEN-PC . 附加 信息: 无法 打开 用户 默认 数据库. 登录 失败. 登录 失败 用户"BEN-PC \ Ben". (Microsoft SQL 服务器，错误: 4064) 获得 帮助，点击: http: // go.microsoft/fwlink?ProdName=Microsoft + SQL + Server& EvtSrc = MSSQLServer& EvtID = 4064& LinkId = 20476

解决方案

转到SQL Server Management Studio. 正常登录，然后在左侧窗格(对象资源管理器")中右键单击数据库". 选择附加..."并按照对话框进行操作.

引用:

www .linglom/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/ www.c-sharpcorner/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/ www.packtpub/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps www.mssqltips/sqlservertip/1894/attach-a-sql-server-database-with-a-missing-transaction-log-file/

Hi all, I changed my SQL server options so the specific DB is the default DB and the other day I detatched the DB for some reason and know I can''t connect to my SQL server because its looking for that specific DB that I detatched. When I press the connect button in SQL Server Management Studio it gives me this error: And doesn''t connect

Connect to Server Cannot connect to BEN-PC. ADDITIONAL INFORMATION: Cannot open user default database. Login failed. Login failed for user 'BEN-PC\Ben'. (Microsoft SQL Server, Error: 4064) For help, click: go.microsoft/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

Please help what can I do?

解决方案

Go to SQL Server Management Studio. Log in as normal, then right click "Databases" in the Left hand pane ("Object explorer"). Select "Attach..." and follow the dialogs.

Quote:

www.linglom/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/ www.c-sharpcorner/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/ www.packtpub/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps www.mssqltips/sqlservertip/1894/attach-a-sql-server-database-with-a-missing-transaction-log-file/