Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / SQL Server Tools / July 2008

Tip: Looking for answers? Try searching our database.

DBCC & Transaction Logs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 15 Jul 2008 11:26 GMT
Hi
I'm a newbie in the SQL world
I have to shrink the transaction Log of an SQL 2000 Database

So I googled around and found that I have to use the command
DBCC SHRINKFILE

But I can't find the file DBCC anywhere on my server?
Where can I find it or download it?

Or is there another way to shrink the transaction Logs?
and avoid future overload of my DB due to many transaction logs?
Ekrem Önsoy - 15 Jul 2008 11:57 GMT
Welcome to this world Dave =)

You need to investigate Database Rovery Models. Then you should choose the
appropriate one for your database. You can have information about this topic
from this link: http://msdn.microsoft.com/en-us/library/aa173531.aspx

Then you should read Tibor's article about shrinking. Using this article,
you'll know when to shrink it and why you should not perform this action any
time: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

DBCC commands are not something to download. There are some DBCC Commands
that you can use in certain cases. You can have information about DBCC
commands from Books Online:
http://msdn.microsoft.com/en-us/library/aa258281(SQL.80).aspx

Books Online (BOL) is a SQL Server referance e-encyclopedia. Take advantage
of it!: http://msdn2.microsoft.com/en-us/library/bb545450.aspx

Signature

Ekrem Önsoy

> Hi
> I'm a newbie in the SQL world
[quoted text clipped - 8 lines]
> Or is there another way to shrink the transaction Logs?
> and avoid future overload of my DB due to many transaction logs?
Dave - 15 Jul 2008 16:04 GMT
Thx

Problem solved I thought it was a dos command in stead of a query.

>Welcome to this world Dave =)
>
[quoted text clipped - 13 lines]
>Books Online (BOL) is a SQL Server referance e-encyclopedia. Take advantage
>of it!: http://msdn2.microsoft.com/en-us/library/bb545450.aspx
Erland Sommarskog - 15 Jul 2008 23:34 GMT
> You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)

(Sorry, couldn't resist.)

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Ekrem Önsoy - 15 Jul 2008 15:39 GMT
ehe =)

Signature

Ekrem Önsoy

>> You need to investigate Database Rovery Models.
>
> Surely you mean Database Robbery Models? :-)
>
> (Sorry, couldn't resist.)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.