I am trying to run DBCC SHRINKFILE() agsinst a specific database and the
task has been running for hours now. Is it safe to kill the task in the
middle? are there any chances it will bring the db to suspect if it is killed
in the middle.
Any schematics to diagnose why it is taking so long or can we check if it is
performing any work or not?
> Environment: SQL 2000
>
> I am trying to run DBCC SHRINKFILE() agsinst a specific database and the
> task has been running for hours now. Is it safe to kill the task in the
> middle? are there any chances it will bring the db to suspect if it is killed
> in the middle.
>
> Any schematics to diagnose why it is taking so long or can we check if it is
> performing any work or not?
>
> TIA
>
SQL Server Developer >> DBCC SHRINKFILE
Yes, you can kill the connection now. All SQL Server is doing is
reorganising the pages to free the end of the file. Next time you run the
shrink operation it will take less time as some/most of the work has been
done.
You can do the shrink in smaller chunks. For example, shrink 100mb at a time
instead of 1GB all at once. That way you will know the progress and each
operation will be a lot quicker.
David
> Environment: SQL 2000
>
> I am trying to run DBCC SHRINKFILE() agsinst a specific database and the
> task has been running for hours now. Is it safe to kill the task in the
> middle? are there any chances it will bring the db to suspect if it is
> killed
> in the middle.
>
> Any schematics to diagnose why it is taking so long or can we check if it
> is
> performing any work or not?
>
> TIA
>
SQL Server Developer >> DBCC SHRINKFILE
Thanks to BOTH
> Yes, you can kill the connection now. All SQL Server is doing is
> reorganising the pages to free the end of the file. Next time you run the
> shrink operation it will take less time as some/most of the work has been
> done.
>
> You can do the shrink in smaller chunks. For example, shrink 100mb at a time
> instead of 1GB all at once. That way you will know the progress and each
> operation will be a lot quicker.
>
> David
>
> > Environment: SQL 2000
> >
> > I am trying to run DBCC SHRINKFILE() agsinst a specific database and the
> > task has been running for hours now. Is it safe to kill the task in the
> > middle? are there any chances it will bring the db to suspect if it is
> > killed
> > in the middle.
> >
> > Any schematics to diagnose why it is taking so long or can we check if it
> > is
> > performing any work or not?
> >
> > TIA
> >
>
>
>