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-02-05 : 09:08:04
|
| Paul writes "Hi.I have a broken MSSQL 6.5 database and NO backup. I use description of pages in database device from Ron Soukap's "Inside SQL Server 6.5" book to analyze device files and extract valuable data.The problem is that information stored in device files differs from that DBCC PAGE returns. Using my scan program I've found that some fields on page header are equal (e.g. objid) and some are different (e.g. nextrno). It seems that SQL server processes device files and fills page headers with real data while working. Is it really so?Are there any conversion tasks that SQL server do with device file while working with databases?Thanks in advance, Paul." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-05 : 10:53:48
|
| I would seriously suggest opening a MS PSS case. They have experts in data corruption that may be able to help you recover your database.-Chad |
 |
|
|
pyak
Starting Member
2 Posts |
Posted - 2002-02-07 : 06:04:32
|
quote:
I would seriously suggest opening a MS PSS case. They have experts in data corruption that may be able to help you recover your database.-Chad
Excuse me, but how can I do it (open a MS PSS case)?Paul |
|
|
|
izaltsman
A custom title
1139 Posts |
|
|
|
|
|
DBCC PAGE and real data on disk