Error restoring database

I get this error when restoring from a backup:
--
...
97 percent restored.
98 percent restored.
99 percent restored.
100 percent restored.
Processed 2811832 pages for database 'develop', file 'internalData' on file
1.
Processed 84368 pages for database 'develop', file 'internal3' on file 1.
Processed 3 pages for database 'develop', file 'intlog' on file 1.
Server: Msg 3624, Level 20, State 1, Line 10
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 52
Process ID: 1208
Connection Broken
--
VERSION INFO:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I really need some code from this db. Any help would be appreciated.
DougSounds like you ran into some kind of data corruption. If
possible, I'd run DBCC CHECKDB, and also try to verify the
integrity of the disk subsystem. But to be sure, a call to
the Microsoft support may be in order.
Linchi
>--Original Message--
>I get this error when restoring from a backup:
>--
>....
>97 percent restored.
>98 percent restored.
>99 percent restored.
>100 percent restored.
>Processed 2811832 pages for database 'develop',
file 'internalData' on file
>1.
>Processed 84368 pages for database 'develop',
file 'internal3' on file 1.
>Processed 3 pages for database 'develop', file 'intlog'
on file 1.
>Server: Msg 3624, Level 20, State 1, Line 10
>Location: recbase.cpp:1378
>Expression: m_offBeginVar < m_SizeRec
>SPID: 52
>Process ID: 1208
>Connection Broken
>--
>VERSION INFO:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service
Pack 4)
>I really need some code from this db. Any help would be
appreciated.
>Doug
>
>.
>|||Hi,
Can you provide me the size of the Develop database.
If the size is small , use DTS to transfer all objects to a new database and
then perform a Backup.
Note:
Before performing DTS, use DBCC CheckDB command to identify the corrupted
object.
Thanks
Hari
MCDBA
"Doug Stiers" <stiers@.email.com> wrote in message
news:#lH4BjJ1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> I get this error when restoring from a backup:
> --
> ...
> 97 percent restored.
> 98 percent restored.
> 99 percent restored.
> 100 percent restored.
> Processed 2811832 pages for database 'develop', file 'internalData' on
file
> 1.
> Processed 84368 pages for database 'develop', file 'internal3' on file 1.
> Processed 3 pages for database 'develop', file 'intlog' on file 1.
> Server: Msg 3624, Level 20, State 1, Line 10
> Location: recbase.cpp:1378
> Expression: m_offBeginVar < m_SizeRec
> SPID: 52
> Process ID: 1208
> Connection Broken
> --
> VERSION INFO:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> I really need some code from this db. Any help would be appreciated.
> Doug
>
>|||Hari,
That's what I was going to do but the database is suspect. I cannot get into
the database at all.
Doug
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:usVgJxP1DHA.1744@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Can you provide me the size of the Develop database.
> If the size is small , use DTS to transfer all objects to a new database
and
> then perform a Backup.
> Note:
> Before performing DTS, use DBCC CheckDB command to identify the corrupted
> object.
>
> Thanks
> Hari
> MCDBA
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:#lH4BjJ1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> > I get this error when restoring from a backup:
> > --
> > ...
> > 97 percent restored.
> > 98 percent restored.
> > 99 percent restored.
> > 100 percent restored.
> > Processed 2811832 pages for database 'develop', file 'internalData' on
> file
> > 1.
> > Processed 84368 pages for database 'develop', file 'internal3' on file
1.
> > Processed 3 pages for database 'develop', file 'intlog' on file 1.
> > Server: Msg 3624, Level 20, State 1, Line 10
> >
> > Location: recbase.cpp:1378
> > Expression: m_offBeginVar < m_SizeRec
> > SPID: 52
> > Process ID: 1208
> >
> > Connection Broken
> > --
> >
> > VERSION INFO:
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> >
> > I really need some code from this db. Any help would be appreciated.
> > Doug
> >
> >
> >
>|||Hi Doug,
Start the database in emergency mode and perform DTS to a new database.
How to start database in emergency mode,
update sysdatabases
set status=32768
where name='dbname'
Thanks
Hari
MCDBA
"Doug Stiers" <stiers@.email.com> wrote in message
news:uPfRtQR1DHA.1272@.TK2MSFTNGP12.phx.gbl...
> Hari,
> That's what I was going to do but the database is suspect. I cannot get
into
> the database at all.
> Doug
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:usVgJxP1DHA.1744@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > Can you provide me the size of the Develop database.
> >
> > If the size is small , use DTS to transfer all objects to a new database
> and
> > then perform a Backup.
> >
> > Note:
> >
> > Before performing DTS, use DBCC CheckDB command to identify the
corrupted
> > object.
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Doug Stiers" <stiers@.email.com> wrote in message
> > news:#lH4BjJ1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> > > I get this error when restoring from a backup:
> > > --
> > > ...
> > > 97 percent restored.
> > > 98 percent restored.
> > > 99 percent restored.
> > > 100 percent restored.
> > > Processed 2811832 pages for database 'develop', file 'internalData' on
> > file
> > > 1.
> > > Processed 84368 pages for database 'develop', file 'internal3' on file
> 1.
> > > Processed 3 pages for database 'develop', file 'intlog' on file 1.
> > > Server: Msg 3624, Level 20, State 1, Line 10
> > >
> > > Location: recbase.cpp:1378
> > > Expression: m_offBeginVar < m_SizeRec
> > > SPID: 52
> > > Process ID: 1208
> > >
> > > Connection Broken
> > > --
> > >
> > > VERSION INFO:
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > > Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation
> > > Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> > >
> > > I really need some code from this db. Any help would be appreciated.
> > > Doug
> > >
> > >
> > >
> >
> >
>