I recommend to use the option below only in a development environment, not
production.
See this link for more details.
http://www.databasejournal.com/features/mssql/article.php/1440901
Jorge A. Herrera
MSSQL DBA
Chevy Chase Bank
6200 Chevy Chase Drive
Laurel, MD. 20707
[Email Address Removed] Message-----
From: Harris, Heather [mailto:[Email Address Removed] Wednesday, April 28, 2004 10: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] is to be used for Chevy Chase Bank business purposes only.
Confidential information should not be sent via email as there is no
expectation of privacy or integrity of the message through the Internet.
**********************************************************************
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error
please notify the system manager.
This footnote confirms that this email message has been scanned
for the presence of computer viruses.
Chevy Chase Bank
**********************************************************************
MS Sql Server LazyDBA home page