"HardKhor" wrote:

> Hi all,
>
> 1) I am currently deleting a publication of a rather large DB (approx 8 GB)
> during off hours. It is taking an incredibly long time (more than 1 hour
> already). Does anyone know why does SQL Server take such a long time just to
> delete a publication?
>
> And I already have remove all subscriptions to that publication before I
> started deleting it. I am using SQL Server 2000.
>
> 2) If I just shut down the server, and restart it (in order to kill off the
> deletion process), will that be any side-effects?
>
> Any help is greatly appreciately.
>