.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

error 3316 and database in suspect mode

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Hi all, 

my database fell into suspect mode. I fixed database using dbcc checkdb in emergency mode and now it seems ok. But I dont know why this incident occurs. does anybody know possible reason?

In error log I found these records:

ex_raise2: Exception raised, major=52, minor=42, state=13, severity=22, attempting to create symptom dump... followed by dump information ... and then errors 3316, 3314, 9001 (in this order)

cluster manager does not register any event about SAN outage

thanks for any answer.


View Complete Post

More Related Resource Links

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

Database goes to suspect mode


Hi Team,


Two days back i went one DBA interview he is asked some dba questions 


Q. we have 25 database in this one database is goes to suspect mode. How do you know x database is goes to suspect mode.


      i said we got one alert or mail x database is goes to suspect mode 


my be my answer is wrong could you any body please give me exact answer for this.


Q. we have 14 instances one instance is correpected or it goes to suspect mode how can we know x instance goes to suspect mode ?



Can you any body please guide me for this one.. i m bit confue on this my expectation instance could not goes to suspect mode right can you correct me.






database stuck in emergency mode error 952


Please help.  Database is stuck in emergency mode and cannot enter into single_user.  Please help!!

Dr. William Sewell

SQL SERver 2000 database is in offline\suspect\Emergency mode



I m having sql server 2000 database and 4-5 database is in offline\suspect\Emergency .

I have tried that to take online throgh following step:

EXEC sp_resetstatus 'DBName'

DBCC checkdb('DBname')
DBCC CheckDB ('DBName')





From this command :

but its not coming online and multiuser then i run this command : UPDATE SYSDATABASES SET STATUS=24 WHERE NAME='DBNAME' and it comes online but whenever sql sever services get restarted it again goes into suspect mode.


Please help somebody?


ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch


Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50

The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Activation error occured while trying to get instance of type Database, key "DBName"


Im using Enterprise library 5.0
I have a scenario, where I have to access two different databases in my application.

Basically this application is a webservice,delployed on my local for testing purpose.
I'm trying to access this web method from diffent windows application, default connection works fine but the other database throw's exception.

Problem is only my defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with "MYCON2" it works fine, if I try to access the other database which is not default, throws exception.

<dataConfiguration defaultDatabase="MYCON1" />
<add name="MYCON1" connectionString="Data Source=server1;Initial Catalog=dbName1;User Id=Username1;Password=password1;"

" />
<add name="MYCON2" connectionString="Data Source=Server2;Initial Catalog=dbName2;User Id=Username2;Password=password2;"
providerName="System.Data.SqlClient" />

Database myDB=EnterpriseLibraryContainer.Current.GetInstance<Database>(); --> works fine for the default database (MYCON1)

Database myDB=EnterpriseLibraryCo

How to fix error in MVC movie database tutorial from Asp.net?


I followed the tutorial at http://www.asp.net/mvc/videos/creating-a-movie-database-application-in-15-minutes-with-aspnet-mvc At 12:04 in the video, the author,  Stephen Walther. inclues the line

            return View(_entities.MovieSet.ToList());
When I tried to compile this I get an error: 
Error 1 'MovieApp.Controllers.MoviesDbEntities' does not contain a definition for 'MovieSet' and no extension method 'MovieSet' accepting a first argument of type 'MovieApp.Controllers.MoviesDbEntities' could be found (are you missing a using directive or an assembly reference?) P:\experiment\MovieApp\MovieApp\Controllers\HomeController.cs 18 35 MovieApp

If I just enter return View(_entities. then Intellisense  offers Equals, GetHashCode, GetType, and TosString.

Does this suggest that _entities is not being i

WPF+ VS2010: Design mode error "The URI prefix is not recognized"?

our application uses VS2008 and WPF. To apply the styles in the design mode, we have used the "BlendMergedDictionary" class (see the following link) http://stackoverflow.com/questions/995101/how-do-i-get-wysiwyg-design-in-blend-vs-without-merged-resourcedictionary-in-ever It works very well in VS2008 IDE. Now we plan to move our application to VS2010. In VS2010 Design mode (click on ~.xaml design), we get error message:  "The URI prefix is not recognized."    at System.Net.WebRequest.Create(Uri requestUri, Boolean userUriBase)    at System.Net.WebRequest.Create(Uri requestUri)    at MS.Internal.WpfWebRequestHelper.CreateRequest(Uri uri)    at System.Windows.ResourceDictionary.set_Source(Uri value) the styles does not apply at the design time. It works fine in runtime. The following are the code: public class BlendMergedDictionary : ResourceDictionary { /// <summary> /// This class the purpose is allow we reference the "themes" and "styles" in resource dictionaries in separated assemblies /// by using StaticResource. The big problem using StaticResource is that it will complaints at design time can not find the resources /// So we use this class in xaml file, if it is design time, it will load the resource dictionaries in. /// If it is not in design time, it will use the reso

DATABASE/ADO ERROR need help asap please!

  We are running SQL server 2005 under WS 2003.  This error is showing up in our log every time there is a select.  I  have looked everywhere for a solution and cannot find one that works.       DATABASE/ADO ERROR  Error Number: -2147467259 Error Description: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()). Error Source: Microsoft OLE DB Provider for ODBC Drivers  

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

Database is looking as (Suspect/readonly/offline/emergency/)

Could not open FCB for invalid file ID 0 in database 'mssc_admin' and database is looking as (Suspect/readonly/offline/emergency/) Actually log file is not visibiling and I was trying to restore it.   PLease PLease help"SQLSERVER DBA" "INDIA"

My Sql server 2005 Database in recovery mode for 3 -4 hours every day

Hi , Some of our Sql Server 2005 databases remain in recovery mode after midnight for almost 3 to 4 hours. So when my application access them error "Databse in recovery" and for same database this happens again and again every night. Please suggest why and how this can be solved?

Windows 7 CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 26

Hi I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2.  I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.  Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work. I have admin privaleges on my machine.  There are no other accounts.    What do I need to do to update privaleges? Thanks and have a nice day.    

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in transition...Error 952". We were trying to Take the DB offline when this problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks. What resolved the problem? Re-starting manamgement studio on client machine. Go Figure!

Crystal Report Export - Database Logon Failed Error -

 Below is my code in VB.Net.  I am using PUSH method to populate the DataSet.  I use Crystal Report and VS 2003.   I am trying to export a crystal report to a PDF and I am getting a database log on error.   Why would it give me this error since the report is getting its data from the DataSet.  Please help!!!  ---------------------------------------------- Try Dim oStream As New MemoryStream Me.crpt_numIssues.ExportToStream(ExportFormatType.PortableDocFormat) Response.Clear() Response.Buffer = True Response.ContentType = "application/pdf" Response.BinaryWrite(oStream.ToArray()) Response.End() Catch ex As Exception Dim mgsText As String mgsText = "ERROR: An error occured. <br>" + ex.ToString Me.ShowErrorPanel(mgsText) End Try ------------------------------ The error is: CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqCo

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

SQLServerAgent could not be started (reason: Startup error: The 'msdb' database does not exist)

After installing Service pack 3 for Microsoft SQL Server 2005 the SQLServerAgent wont start: From SQLAGENT.OUT: 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'master.dbo.sysdatabases'. [SQLSTATE 42S02] 2010-08-30 17:10:08 - ! [000] Startup error: The 'msdb' database does not exist 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ? [098] SQLServerAgent terminated (normally)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend