If a database is marked suspect and good backup copies of the database and TLog are available, what steps should be taken to successfully recover the database by restoring the database and Tlog backups?
View Complete Post
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.
I woke up this morning to find my company's SQL database inaccessible and marked suspect.
I haveÃÂ used various t-sql commands to bring it into Emergency mode.
Now it is labelled Loading\Offline\Read-Only\Emergency Mode.
I'm using SQL Server 2000
I do not haveÃÂ a backup and I need to get the database up and running as soon as yesterday.
I am getting this error message and my SQL 2005 database is showing "SUSPECT". I need to recover the transcations in the latest transcation log.
The log scan number (195881:359:1) passed to log scan in database 'XXXXXX' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication.
Otherwise, restore from backup if the problem results in a failure during startup.
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.
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'
ALTER DATABASE DBName SET EMERGENCY
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName')
2. ALTER DATABASE DBName SET MULTI_USER
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?
Multiple database support with Entity Framework One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.