robax
New Member
Posts:3
 |
| 19 Feb 2009 05:57 PM |
|
Hi Mitchel,
SQL Server 2008 has a different procedure from 2000/2005 for shrinking the db. It involves switching the recovery model from full to simple and back afterwards. Does this module take that into account?
Regards,
Rob |
|
|
|
|
Mitchel Sellers
Site Moderator
Basic Member
Posts:337
|
| 19 Feb 2009 06:07 PM |
|
Rob,
I have not fully tested the shrink procedure on 2008.
Right now the task simply uses the DBCC SHRINKDATABASE process to do it.
If you know the code necessary to do it the different way in 2008, I can give you a script to add the type to the system so it can function. |
|
-Mitchel Sellers, Microsoft C# MVP, MCITP
CEO
IowaComputerGurus Inc!
Visit my blog for helpful technical articles
For recommended products and services view the links to the right. |
|
|
robax
New Member
Posts:3
|
| 20 Feb 2009 12:19 AM |
|
Ok yep, that won't shrink it by itself.
Here's the basic info from MSDN
http://msdn.microsoft.com/en-us/library/ms189035.aspx
and here
http://msdn.microsoft.com/en-us/library/ms189493.aspx
I've been doing it directly in SQL management studio so far but it would be handy to have it automated. I go to the properties, set the recovery model to simple, access the shrink db task, and then return it to full again.
Ok, here's the one I was looking for - it has bits for 2000,2005 and 2008:
http://madhuottapalam.blogspot.com/2008/05/faq-how-to-truncate-and-shrink.html
Rob |
|
|
|
|