Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
RE: [ISSForum] RE: [IS Forum] Problems with Database Maintenance Service
From: Nicholas EK Ng (nicholassilicon.net.my)
Date: Wed Aug 13 2003 - 03:35:55 CDT
You can configure auto-shrink in MSSQL 7.0. You can even set a schedule to
shrink your ISSED database.
To configure auto-shrink:
1) Right click on your issed database. Go to Properties
2) Go to the Option tab where you will see the auto-shrink check box.
3) Check the auto shrink box
To schedule a shrink process:
1) Right click on issed database.
2) Go to All Tasks
3) Select Shrink Database
4) You can set the database shrink schedule in the shrink database window.
Hope this helps.
Nicholas EK Ng
Silicon Communications S/B
From: issforum-adminiss.net [mailto:issforum-adminiss.net]On Behalf Of
Sent: Friday, August 01, 2003 10:51 PM
To: mmvitoriocoelba.com.br; issforumiss.net
Subject: [ISSForum] RE: [IS Forum] Problems with Database Maintenance
The database itself will not shrink once SQL has allocated the drive space
it will continue to use it. Now when you remove items SQL will then reuse
that space. This means if you have a 2gig database and remove 1gig of data
then the database will not grow again until you use that 1 gig. There are
tools within SQL to shrink the database but if you have the drive space I
don't recommend this as the database will just grow back up.
From: mmvitoriocoelba.com.br [mailto:mmvitoriocoelba.com.br]
Sent: Thursday, July 31, 2003 6:27 AM
Subject: [ISSForum] Problems with Database Maintenance Service
Hello all... Iīm running Database Maintenance Service to purge some records
and itīs spending a lot o time to do this. After it finished the job, i
looked for the space used by the database (SQL Server 7.0) and itīs didnīt
What iīm doing wrong? This tool works fine? What i have to do to eliminate
This message contains information that may be confidential and privileged.
Unless you are the addressee (or authorized to receive messages for the
addressee), you may not use, copy, or disclose to anyone the message or any
information contained in the message. If you have received the message in
error, please advise the sender by reply e-mail and delete the message.
Nothing in this message should be interpreted as a digital or electronic
signature that can be used to authenticate a contract or any other legal
ISSForum mailing list
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
- application/ms-tnef attachment: winmail.dat