Converting a database

[Tara]

I'm compacting a database that is currently 1.5gig and
have hopefully reduced the size by deleting a large number
of image files on the database. My question is what is
the normal amount of time for a database to be compacted,
as this has taken over 45 minutes.

 

[John Spencer (MVP)]

45 minutes is a long time for this to happen, but if you are doing it over a
network (especially a slow network) then it could be still compacting.

On the other hand, it could be hung up.

Also, how fast is your computer, how much RAM do you have, how many processes
are open, how much free disk space do you have, ...

Lots of variables, but the bottom line is I would normally expect the compact to
have finished within 45 minutes.