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 |
|
mmkbt
Starting Member
2 Posts |
 Posted - 2011-06-07 : 00:55:48
|
| Last week when I performed Database Dump for my company ACCPAC. The database failed with the following error message:Description: FETCH [microsoft][ODBC SQL Server Driver][SQL Server}Warning: Fatal error 823 occurred at Jun 4 2011 5.56pm (ec=49153)Source: 17:56:18Can any expert help me for providing me solutins?Thanks. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-07 : 01:41:26
|
That's a hardware error, you've got a corrupt database.Please run the following, post the full and complete results.DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS Do you have a backup of that DB?--Gail ShawSQL Server MVP |
 |
|
|
mmkbt
Starting Member
2 Posts |
Posted - 2011-06-07 : 03:26:18
|
| I did backup the SQL DB. Please show me the steps to run the test.Thanks for your help. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-07 : 04:28:04
|
| Please run the following from a query window, post the full and complete results.DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGSDo you have a backup from before this error occurred? A backup from after is going to be quite useless.How critical is the data in this DB/ Is there a SQL DBA there?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
URGENT: SQL Server Problem.