I'm running SQL Server 7.0 on a 450 NT 4.0 server with 256 MB of memeory and two 25 GB disk drives. My database called SDE is 9 GB in size. Yesterday I entered
dbcc shrinkdatabase (SDE)
in the Query Analyzer window to try and regain some disk space. After 19.5 hours the process is still running. There is nothing else running on the server. Is shrinking a database always so slow? How can I estimate in advance the time required to shrink a database? Is shrinking a database of this size ever viable?