| Author |
 Topic  |
|
|
suman.reddy39
Starting Member
India
34 Posts |
 Posted - 01/20/2009 : 05:06:32
|
DEAR ALL,
I GOT AND URGENT PROBLEM WITH 1 OF MY DATABASES AS IT WENT IN TO SUSPECT MODE CAN ANY 1 HELP ME IN THIS REGARDS AS I HAVE RUN THE SCRIPT
sp_resetstatus db_name
BUT STILL THERE WAS NO CHANGE IN IT
thanks in advance
Don't go the way Life takes you, Take the Life the way you go
subbi |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 01/20/2009 : 05:17:26
|
Hi,
In this stage u have two options
1.Restore the latest available backup
2.Access the database in Emergency mode and Bulk copy all the tables to another temp database. |
 |
|
|
suman.reddy39
Starting Member
India
34 Posts |
Posted - 01/20/2009 : 05:25:13
|
During redoing of a logged operation in database 'OUICQC', an error occurred at log record ID (2640:317:31). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Error: 3414, Severity: 21, State: 1.
An error occurred during recovery, preventing the database 'OUICQC' (database ID 11) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
i got this message when i went to error log file
i dont have a backup for this db
Don't go the way Life takes you, Take the Life the way you go
subbi |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
|
| |
Topic |
|
DATABASE WENT TO SUSPECT MODE
