Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
suman.reddy39
Starting Member
34 Posts |
Posted - 2009-01-20 : 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 SCRIPTsp_resetstatus db_nameBUT STILL THERE WAS NO CHANGE IN ITthanks in advanceDon't go the way Life takes you, Take the Life the way you gosubbi |
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-20 : 05:17:26
|
Hi,In this stage u have two options1.Restore the latest available backup2.Access the database in Emergency mode and Bulk copy all the tables to another temp database. |
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2009-01-20 : 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 filei dont have a backup for this dbDon't go the way Life takes you, Take the Life the way you gosubbi |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
|