dbcc utility

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Liam Mac (LiamMac_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 04:11:08 -0800

Hi,
I have a ms sql 2000 log file that has grown to 50gb in sizes. I have been
researching the web on how i would be able to shrink the log. The utility
that people mention is called "dbcc". However I cannot find this utility has
part of the installation of SQL 2000 server or on the SQL server cd. Where
can I find this utility or download it from ?

any help would be great.
thanks,
Liam

Relevant Pages

  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: Alternate to RDA
    ... Saves me a lot of time on researching. ... strict group and local policies rights, why was IIS chosen ... > I'm not aware of any other way to connect to SQL Server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Error 42d during Fail Over SQL 2000 Enterprise in a Server 2003 Ent. Cluster
    ... Look for the location of the SQL agent log file and make sure it is a clustered resource in the SQL group. ... There is a bug in the install/configure routines that allows the log file to be placed in an incorrect cluster location. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Problem with starting SQL Server 2000
    ... I have looked into the exception log file within C:\Program Files\Microsoft ... > It sounds like your SQL Server service has not started, ... > You should have some information in the SQL Server error log file and the ... >> restarting my pc, without download or updating or installing anything. ...
    (microsoft.public.sqlserver.server)