From: Nicholas EK Ng (nicholassilicon.net.my)
Date: Wed Aug 13 2003 - 03:35:55 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.
 
Regards,
 
Nicholas EK Ng
Security Engineer
Silicon Communications S/B
 
 
  
-----Original Message-----
From: issforum-adminiss.net [mailto:issforum-adminiss.net]On Behalf Of
Eric Parks
Sent: Friday, August 01, 2003 10:51 PM
To: mmvitoriocoelba.com.br; issforumiss.net
Subject: [ISSForum] RE: [IS Forum] Problems with Database Maintenance
Service

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.
 
Eric Parks
Network Engineer
Phone: (559)642-0320
Fax: (559)692-9006
Email: ericpstcg.net
 
-----Original Message-----
From: mmvitoriocoelba.com.br [mailto:mmvitoriocoelba.com.br]
Sent: Thursday, July 31, 2003 6:27 AM
To: issforumiss.net
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
shrink.

What i´m doing wrong? This tool works fine? What i have to do to eliminate
old records?

Thanks,

Marcelo Martinho

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
document.

_______________________________________________
ISSForum mailing list
ISSForumiss.net

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo

• application/ms-tnef attachment: winmail.dat

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]