check database integrity

Folks, do you know some way or tool to check the database integrity and
repair error like corrupt entries to a d/b in sql 2k?
Thanks
DanielDBCC = Database consistency checker. Have a look in SQL BOL
Try DBCC CHECKDB to start
--
HTH
Ryan Waight, MCDBA, MCSE
"Daniel_A" <dabella@.empower.edu.uy> wrote in message
news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> Folks, do you know some way or tool to check the database integrity and
> repair error like corrupt entries to a d/b in sql 2k?
> Thanks
> Daniel
>
>|||Ryan,
DBCC is an abbreviation for Database Console Command.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:OBkItUSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> DBCC = Database consistency checker. Have a look in SQL BOL
> Try DBCC CHECKDB to start
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Daniel_A" <dabella@.empower.edu.uy> wrote in message
> news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> > Folks, do you know some way or tool to check the database integrity and
> > repair error like corrupt entries to a d/b in sql 2k?
> >
> > Thanks
> >
> > Daniel
> >
> >
> >
>|||If i'm wrong i stand corrected. Can't find a translation on Microsoft but...
I got the following from the Sybase site...
What Is the Database Consistency Checker?
The database consistency checker (dbcc) provides commands for checking the
logical and physical consistency of a database. Two major functions of dbcc
are:
http://manuals.sybase.com/onlinebooks/group-as/asg1200e/asesag/@.ebt-link;pt=57217?target=%25N%15_57285_START_RESTART_N%25
HTH
Ryan Waight, MCDBA, MCSE
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23%23QpfeSfDHA.3896@.tk2msftngp13.phx.gbl...
> Ryan,
> DBCC is an abbreviation for Database Console Command.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:OBkItUSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> > DBCC = Database consistency checker. Have a look in SQL BOL
> >
> > Try DBCC CHECKDB to start
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Daniel_A" <dabella@.empower.edu.uy> wrote in message
> > news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> > > Folks, do you know some way or tool to check the database integrity
and
> > > repair error like corrupt entries to a d/b in sql 2k?
> > >
> > > Thanks
> > >
> > > Daniel
> > >
> > >
> > >
> >
> >
>|||Ryan,
Its mentioned in BooksOnLine:
'DBCC'
http://msdn.microsoft.com/library/en-us/tsqlref/ts_dbcc_217n.asp?frame=true
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%234aktjSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> If i'm wrong i stand corrected. Can't find a translation on Microsoft
but...
> I got the following from the Sybase site...
> What Is the Database Consistency Checker?
> The database consistency checker (dbcc) provides commands for checking the
> logical and physical consistency of a database. Two major functions of
dbcc
> are:
>
http://manuals.sybase.com/onlinebooks/group-as/asg1200e/asesag/@.ebt-link;pt=57217?target=%25N%15_57285_START_RESTART_N%25
>
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:%23%23QpfeSfDHA.3896@.tk2msftngp13.phx.gbl...
> > Ryan,
> >
> > DBCC is an abbreviation for Database Console Command.
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > news:OBkItUSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> > > DBCC = Database consistency checker. Have a look in SQL BOL
> > >
> > > Try DBCC CHECKDB to start
> > >
> > > --
> > > HTH
> > > Ryan Waight, MCDBA, MCSE
> > >
> > > "Daniel_A" <dabella@.empower.edu.uy> wrote in message
> > > news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> > > > Folks, do you know some way or tool to check the database integrity
> and
> > > > repair error like corrupt entries to a d/b in sql 2k?
> > > >
> > > > Thanks
> > > >
> > > > Daniel
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thanks, have a look at a response to Event ID 17055 by Scott Morris. It's
posted under the wrong subject but is about DBCC.
In his version of BOL searching for DBCC (T-SQL) returns Database
Consistency Checker
In my version it states Database Console Command
The acronym appears to have changed meaning between version.
From now on I'll be using Database Console Command
--
HTH
Ryan Waight, MCDBA, MCSE
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:eH1lmpSfDHA.3700@.TK2MSFTNGP11.phx.gbl...
> Ryan,
> Its mentioned in BooksOnLine:
> 'DBCC'
>
http://msdn.microsoft.com/library/en-us/tsqlref/ts_dbcc_217n.asp?frame=true
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:%234aktjSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> > If i'm wrong i stand corrected. Can't find a translation on Microsoft
> but...
> >
> > I got the following from the Sybase site...
> > What Is the Database Consistency Checker?
> > The database consistency checker (dbcc) provides commands for checking
the
> > logical and physical consistency of a database. Two major functions of
> dbcc
> > are:
> >
> >
>
http://manuals.sybase.com/onlinebooks/group-as/asg1200e/asesag/@.ebt-link;pt=57217?target=%25N%15_57285_START_RESTART_N%25
> >
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > news:%23%23QpfeSfDHA.3896@.tk2msftngp13.phx.gbl...
> > > Ryan,
> > >
> > > DBCC is an abbreviation for Database Console Command.
> > >
> > > --
> > > Dinesh.
> > > SQL Server FAQ at
> > > http://www.tkdinesh.com
> > >
> > > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > > news:OBkItUSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> > > > DBCC = Database consistency checker. Have a look in SQL BOL
> > > >
> > > > Try DBCC CHECKDB to start
> > > >
> > > > --
> > > > HTH
> > > > Ryan Waight, MCDBA, MCSE
> > > >
> > > > "Daniel_A" <dabella@.empower.edu.uy> wrote in message
> > > > news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> > > > > Folks, do you know some way or tool to check the database
integrity
> > and
> > > > > repair error like corrupt entries to a d/b in sql 2k?
> > > > >
> > > > > Thanks
> > > > >
> > > > > Daniel
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Historically, DBCC was the acronym for DataBase Consistency Checker, and had
the same options as in Sybase.
The basic options have to do with checking the consistency of a table or the
whole database, and verifying the allocation structures. In later releases,
the DBCC command began to be overloaded, and everytime the dev engineers at
Microsoft wanted to add a new non-SQL command, they just tacked it on to
DBCC, so if you check the Books Online you'll see lots of options that have
nothing to do with consistency checking.
For this reason the BOL nows says the acronym means DataBase Console
Command, but that is a case of putting the cart before the horse. We already
had the command, and they just had to find something new for it to mean.
And actually, there is still a reference in BOL for DBCC having the old
meaning. If you look in the System Monitor section, under the description of
SQL Server: Database Object, it will tell you that the "DBCC Logical Scan
Bytes/sec" counter measures
"Number of logical read scan bytes per second for database consistency
checker (DBCC) statements."
So Daniel, DBCC is what you want, especially the CHECKDB and CHECKALLOC
options, but there might be a few others that are useful. Please read the
docs.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:##QpfeSfDHA.3896@.tk2msftngp13.phx.gbl...
> Ryan,
> DBCC is an abbreviation for Database Console Command.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:OBkItUSfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> > DBCC = Database consistency checker. Have a look in SQL BOL
> >
> > Try DBCC CHECKDB to start
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Daniel_A" <dabella@.empower.edu.uy> wrote in message
> > news:%23lG3hSSfDHA.2348@.TK2MSFTNGP12.phx.gbl...
> > > Folks, do you know some way or tool to check the database integrity
and
> > > repair error like corrupt entries to a d/b in sql 2k?
> > >
> > > Thanks
> > >
> > > Daniel
> > >
> > >
> > >
> >
> >
>