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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-06 : 09:11:14
|
| Ryan VH writes "SQL Sever we are useing: SQL Server 6.5 (Service Pack 4) on Windows NT Server (Service pack 6a)We received this error message on 1 of our databases (we have 7 databases):“Attempt to fetch logical page 50 in database ‘(database_name)’, belongs to object ‘0’, not to object ‘sysobjects’”What we tried:When we delete, recreate and reload the database, the error moves to next database. After seeing this, we believe that the Master database and theSQL Server itself was corrupted.The way we fixed the problem was to uninstall SQL, delete all SQL files including data, reinstall SQL, recreate devices, recreated databases and load data from last good backup.Question:What exactly is this error message saying ??What could cause this error message ??Did this error caused the corruption of the Master databaseor the SQL Serve itself ??Is there an easier fix or solution to resolve this error ??" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-07 : 01:18:13
|
| There could be any number of issues that can cause corruption. Particularly in 6.5 where it is relatively common.The best course of action would be to upgrade at least to 7.0. The rearchitecture of the data storage in 7.0 eliminated MUCH of the corruption problems we saw in 6.5. I highly recommend an upgrade. (If you can't upgrade, for god's sake please put the latest SP on!)If/when it occurs again, (If this is an important(Production) Database) you should probably call MS Support.-Chad |
 |
|
|
|
|
|
|
|
error message: “Attempt to fetch logical page 50 in database ‘(db name)’, belongs to object ‘0’, no