[dba-SQLServer]Torn page

Forgot to say, if you have a recent backup etc you can restore the DB


Martin



----- Original Message ----- 
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Wednesday, December 17, 2003 2:04 PM
Subject: Re: [dba-SQLServer]Torn page


> Not that I am aware.
>
> You may even need to recreate a new db and get the exisiting data
> transferred. Did you suffer a recent power failure etc
>
> Martin
>
>
> ----- Original Message ----- 
> From: "John W. Colby" <jcolby at colbyconsulting.com>
> To: "SQLServer" <dba-sqlserver at databaseadvisors.com>
> Sent: Wednesday, December 17, 2003 1:27 PM
> Subject: [dba-SQLServer]Torn page
>
>
> > I get an error entering data into a table of my billing database -
"insert
> > failed - torn page detected".  If I go into the table I am attempting to
> > enter data in,. nothing but #error# in all fields.  Relinked table, same
> > thing.
> >
> > Is this reparable?  If so how?
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>