Auto_shrink

What happens if I stop auto_shrink when it is going on.
Hi,
Auto_Shrink should be running under a system process. For OLTP systems it is
not really a good option to have database option
autoshrink on due to issues like this (Locking , slow performance ...).
So turn off autoshrink option and manage MDF and LDF size issues using dbcc
shrinkfile or dbcc shrinkdatabse
Otherway, If you are stopping a DBCC SHRINKFILE process which you are
executing, then it is fine.
Thanks
Hari
MCDBA
"ISNRao" <ISNRao@.discussions.microsoft.com> wrote in message
news:190A2458-877E-4A2B-A7E8-54B4628BBFA3@.microsoft.com...
> What happens if I stop auto_shrink when it is going on.
|||I think it will stop at the size it has shrunk. It won't roll back.
"ISNRao" <ISNRao@.discussions.microsoft.com> wrote in message
news:190A2458-877E-4A2B-A7E8-54B4628BBFA3@.microsoft.com...
> What happens if I stop auto_shrink when it is going on.
|||Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"ISNRao" <ISNRao@.discussions.microsoft.com> wrote in message
news:190A2458-877E-4A2B-A7E8-54B4628BBFA3@.microsoft.com...
> What happens if I stop auto_shrink when it is going on.
|||Nothing - no work is lost.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"ISNRao" <ISNRao@.discussions.microsoft.com> wrote in message
news:190A2458-877E-4A2B-A7E8-54B4628BBFA3@.microsoft.com...
> What happens if I stop auto_shrink when it is going on.