Solved

Auto Shrink?

Posted on 2009-07-03
1
415 Views
Last Modified: 2012-05-07
Should you auto shrink sql server 2000 databases?
0
Comment
Question by:Bob Schneider
1 Comment
 
LVL 12

Accepted Solution

by:
kevin_u earned 500 total points
ID: 24774110
If you auto shrink, you may end up getting hit by a performance slow down, when the shrink starts.  Since its "auto" you don't know when it will be.

I'd suggest you create a mantenance plan to do the shrinking and any other re-indexing, update statistics, etc at a time of your choosing.  Let SQL Server Agent be your friend.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question