I am using SQL Express 2005. A database has reached its maximum size and needs to be shrunk. Prior to shrinking I checked the database and found several error in the index. So I did a backed up and ran the following script to repair and rebuild
alter database sbsmonitoring set SINGLE_USER
DBCC CHECKDB (sbsmonitoring, repair_rebuild)
alter database sbsmonitoring set MULTI_USER
The script has been running for 24 hours.
Is it normal to take this long to repair and rebuild a 4 gig database?
At what point do I take some action and what steps would I take to correct the situation