dbTalk Databases Forums  

DBCC & Transaction Logs

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools DBCC & Transaction Logs

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss DBCC & Transaction Logs in the microsoft.public.sqlserver.tools forum.



Reply
Page 2 of 4 < 1 2 3 4 >
 
Thread Tools Display Modes
  #11  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM





ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #12  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM





ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #13  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #14  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #15  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #16  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #17  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #18  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #19  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 09:39 AM


ehe =)

--
Ekrem Önsoy



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ekrem Önsoy (ekrem (AT) compecta (DOT) com) writes:
You need to investigate Database Rovery Models.

Surely you mean Database Robbery Models? :-)


(Sorry, couldn't resist.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #20  
Old   
Dave
 
Posts: n/a

Default Re: DBCC & Transaction Logs - 07-15-2008 , 10:04 AM


Thx

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


On Tue, 15 Jul 2008 13:57:18 +0300, Ekrem Önsoy <ekrem (AT) compecta (DOT) com> wrote:

Quote:
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/libr...1(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


Reply With Quote
Reply
Page 2 of 4 < 1 2 3 4 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top