To add with Terry's comment below...
Auto shrinking and growing will definitely affect performance on your system. When the database tries to expand at some stage within the day it will hold some locks on the database thus slowing performance and same with shrinking. But, there are workaround on this topic if you want this badly on your system.
-----Original Message-----
From: Harris, Heather [mailto:[Email Address Removed]
Sent: Thursday, 29 April 2004 3:05 a.m.
To: LazyDBA.com Discussion
Subject: RE: One more question!!!
Explain this statement. I haven't seen any issues w/ this setting thus far.
-----Original Message-----
From: Crosby, Terry [mailto:[Email Address Removed] Wednesday, April 28, 2004 10:49 AM
To: LazyDBA.com Discussion
Subject: RE: One more question!!!
Be wary of auto shrink and the overhead involved with auto shrink and auto grow.
-----Original Message-----
From: Harris, Heather [mailto:[Email Address Removed]
Sent: Wednesday, April 28, 2004 9:07 AM
To: LazyDBA.com Discussion
Subject: RE: One more question!!!
You'll also want to make sure that on the Database Properties, Options tab, you select the Auto Shrink option. When your database is in Simple Recovery mode, the Auto Shrink references the Transaction Log.
Heather Harris
Application Consultant III
Kronos Incorporated - Labor Analytics Division E-mail:[Email Address Removed] <mailto:[Email Address Removed] (813) 287-0555
Fax: (813) 289-4135
www.kronos.com <http://www.kronos.com/>
Improving the Performance of People and Business(tm)
-----Original Message-----
From: Ravi Verma [mailto:[Email Address Removed] Wednesday, April 28, 2004 4:00 AM
To: LazyDBA.com Discussion
Subject: One more question!!!
Hi Gurus,
One more question.
How to schedule the process of automatic truncating and shirnking the log file.
Please suggest.
Ravi Verma
Team Leader eCRM
Cyber Futuristics (I) Pvt.Ltd.
----------------------------------------------------------------------------
--
D-61,2nd Floor,Shiv Heera Path, C-Scheme,Jaipur-302001
Ph:91-141-2366498, 2368166, 2374143 Ext # 24
Website : www.go4customer.com
EMail : [Email Address Removed] , [Email Address Removed]
----------------------------------------------------------------------------
--
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail: mssqldba-[Email Address Removed] , then respond to the confirmation email you get For additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail: mssqldba-[Email Address Removed] , then respond to the confirmation email you get For additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail: mssqldba-[Email Address Removed] , then respond to the confirmation email you get For additional commands, e-mail: mssqldba-[Email Address Removed] mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
----------
The information contained in this e-mail and any attachments is confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.
MS Sql Server LazyDBA home page