在sqlserver 2008中登录后无法获取数据库 [英] Unable to get database after login in sqlserver 2008
问题描述
登录后我无法获取数据库。
错误如下所示。
无法检索请求的数据。( Microsoft.SqlServer.Management.Sdk.Sfc)
附加信息
执行Transact-SQL语句或批处理时发生异常
(microsoft。 SqlServer.ConnectionInfo)
无法打开数据库'msdb'。它已被恢复标记为可疑。请参阅
sqlserver errorlog更多信息(错误926)
请帮帮我。
我尝试了什么:
我重新启动了系统和Sqlserver。
但它不起作用。
I am unable to get database after login.
The error shows below.
Failed to retrieved data for the request.(Microsoft.SqlServer.Management.Sdk.Sfc)
Additional Information
Exception Occurred while executing a Transact-SQL Statement or batch
(microsoft.SqlServer.ConnectionInfo)
Database 'msdb' cannot be opened.It has been marked suspect by recovery.see the
sqlserver errorlog fro more information(Error 926)
please help me.
What I have tried:
I have Restarted the System and Sqlserver.
But it won't work.
推荐答案
请参阅此链接,
1. sql server 2008 r2 - 无法打开数据库MSDB - Stack Overflow [ ^ ]
2. 修复问题数据库‘ msdb’无法打开。它通过恢复被标记为可疑。有关更多信息,请参阅SQL Server错误日志。 (Microsoft SQL Server,错误:926)。在SQL Server 2008–一个旅行者的故事………。 [ ^ ]
Refer this links,
1. sql server 2008 r2 - Database MSDB can not be opened - Stack Overflow[^]
2. Fixing the issue Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926). In SQL Server 2008 – A traveller's story……….[^]
这篇关于在sqlserver 2008中登录后无法获取数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!