I have a db that has one 58 gig data file. The server it was housed on finally ran out of disk space due to this app. I moved stuff off for several years to attempt to keep the app running. The end users have finally agreed to deleting data. After deleting, the data is occupying 35 gig out of the 58. There are numerous indexes, occpuying easily 1/3 of the data file. I started to shrink it. I ran a shrink db ('dbdata',15). As there is not enough room on that server, I moved the db to a new server (3.2 ghz, 4 gig ram, 10,000 RPM RAID 5 drives (300 GIGS)). I have been running shrinkdb for 22 hours. I've been watching activity and saw its has page io latch and the numbers are changing. There is no other activity on the server, I even turned off sql agent. Is this normal for it to take this long?
The server is primarily used as a spare where I restore databases to.