In SQL 2005 when a database is in suspect mode there is no obvious way to tell (via SSMS). In SQL 2000 the word "suspect" was displayed (via Enterprise Manager) next to the database, and the respective database icon was grayed out. Why was this behavior changed for SQL 2005 From a disaster recovery standpoint, it is very important to see immediately if a database is in suspect mode.
Suspect Mode (no icon in SQL 2005)
Hot Topic
- publishing downloading report model
- SQLexpress and autoincrement
- does RS have the mode "push" & "pull" ?
- Allowing Remote Connections
- Default values for a column - From a function
- Could not open a connection to SQL server error on Vista
- SQL Server 2005 Timeout expired exception
- fatal exception when using Access form to display multi-table view in SQL Server 2005
- Upgrade to full version?
- Release unused spaced on tables in SQL2005
SQL Server
- How can I create more instances of the Analysis services server?
- Compatibility with sql 2000
- C# user defined function: Is there a way to access the name of the sql server?
- Passing variables to data flow component
- Need help to install sql reporting services
- Top Instruccion
- ReportService.asmx vs. ReportService2005.asmx
- Using Reporting Services 2005 on SQL Server 2000?
- SQL2005 Notification Services Workflow for MOM2005_SP1
- Importing SQL 2000 data into 2005
Suspect Mode (no icon in SQL 2005)
Maverickcoder
Sameer C T
Computer-Geek
hi all i have a question :
What make's SQL 2005 to mark a database as (SUSPECTED) after the database name
Michael Walker
Done. Feedback ID: 133389
Thanks very much for your help.
Partha Datta
Hi,
I've checked with the SSMS team and this look like a bug. Can you please submit feedback through the Microsoft Connect system (http://connect.microsoft.com) This way we can notify you when the issues is resolved.
Many thanks.
Sriram Krishnan MSFT
Hi Guys,
Is there any update on this issue
I have just installed SQL2005 Sp2 and it doesn't appear to have fixed the problem.
Many thanks
Paul.