dbcc checkdb found 2 errors

I'm in trouble...
dbcc checkdb found 2 errors on my database and this is the first time it was
checked. It says the lowest repair is the "allow data loss". If I run repair
and data is lost, how can I find out which data it is?
Select * from table
does not finish due to
error on page xxxxx.
oh i forgot, the trouble is I don't have a backup without that error, but I
have the way to recreate database but it's huge and I wonder if I could
identify the defect rows and insert only them?
tia
ZarkoMake sure you have an updated books online (Jan 2004) and search for the error numbers in there. Almost all
corruption errors has specific recommendations in the updated Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1086238949.478311@.internet.fina.hr...
> I'm in trouble...
> dbcc checkdb found 2 errors on my database and this is the first time it was
> checked. It says the lowest repair is the "allow data loss". If I run repair
> and data is lost, how can I find out which data it is?
> Select * from table
> does not finish due to
> error on page xxxxx.
> oh i forgot, the trouble is I don't have a backup without that error, but I
> have the way to recreate database but it's huge and I wonder if I could
> identify the defect rows and insert only them?
> tia
> Zarko
>|||Also the errors should give you the page numbers,
you might try to use dbcc page to see if you can look at the page and see
what data is on it..
Google dbcc page
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1086238949.478311@.internet.fina.hr...
> I'm in trouble...
> dbcc checkdb found 2 errors on my database and this is the first time it
was
> checked. It says the lowest repair is the "allow data loss". If I run
repair
> and data is lost, how can I find out which data it is?
> Select * from table
> does not finish due to
> error on page xxxxx.
> oh i forgot, the trouble is I don't have a backup without that error, but
I
> have the way to recreate database but it's huge and I wonder if I could
> identify the defect rows and insert only them?
> tia
> Zarko
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0017_01C4495A.57644590
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
If you could post the errors, we might be able to give you a bit more =insight.
Thanks,
Ryan Stonecipher
MS SQL Server Storage Engine
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message =news:e4uZK0WSEHA.1544@.TK2MSFTNGP09.phx.gbl...
Also the errors should give you the page numbers,
you might try to use dbcc page to see if you can look at the page and =see
what data is on it..
Google dbcc page
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in =message
news:1086238949.478311@.internet.fina.hr...
> I'm in trouble...
>
> dbcc checkdb found 2 errors on my database and this is the first =time it
was
> checked. It says the lowest repair is the "allow data loss". If I =run
repair
> and data is lost, how can I find out which data it is?
> Select * from table
> does not finish due to
> error on page xxxxx.
>
> oh i forgot, the trouble is I don't have a backup without that =error, but
I
> have the way to recreate database but it's huge and I wonder if I =could
> identify the defect rows and insert only them?
>
> tia
>
> Zarko
>
>
--=_NextPart_000_0017_01C4495A.57644590
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

If you could post the errors, we might be able to =give you a bit more insight.
Thanks,
Ryan Stonecipher
MS SQL Server Storage Engine
"Wayne Snyder" wrote in message news:e4uZK0WSEHA.1544=@.TK2MSFTNGP09.phx.gbl...
Also the errors should give you the page numbers,you might try to use =dbcc page to see if you can look at the page and seewhat data is on it..Google dbcc page-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NChttp://www.mariner-usa.com">www.mariner-usa.com(Please =respond only to the newsgroups.)I support the Professional Association =of SQL Server (PASS) and it'scommunity of SQL Server professionals.http://www.sqlpass.org">www.sqlpass.org"Zarko =Jovanovic" wrote in messagenews:1086238949.478311@.i=nternet.fina.hr...> I'm in trouble...>> dbcc checkdb found 2 errors on my =database and this is the first time itwas> checked. It says the =lowest repair is the "allow data loss". If I runrepair> and data =is lost, how can I find out which data it is?> Select * from =table> does not finish due to> error on page xxxxx.>> oh i =forgot, the trouble is I don't have a backup without that error, =butI> have the way to recreate database but it's huge and I wonder if I =could> identify the defect rows and insert only them?>> tia>> =Zarko>>

---

--=_NextPart_000_0017_01C4495A.57644590--