Solved

Auto Shrink?

Posted on 2009-07-03
1
416 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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…

830 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