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 - 2006-02-14 : 09:25:08
|
| VijayaKumar writes "We have SQL Server 7.0 & that machine was crahesd out. We took the .ndf & .ldf files and restore the DB in onther machine.In that machine I am able to Login but during the time of retrival (select query or stored procedure) it gives the following error....Server: Msg 823, Level 24, State 1, Line 1I/O error (bad page ID) detected during read of BUF pointer = 0x1174f100, page ptr = 0x217f8000, pageid = (0x1:0x55b1), dbid = 12, status = 0x801, file = E:\MY\STS_CWS_DB_PRIMARY.ndf.Connection Broken" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-02-14 : 12:40:28
|
| If you don't have a backup, you need to call PSS to help you with this one.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
SQL Server 7.0 - ndf restoration