I have a dabase for which 170gig of space was reserved, but used only 65. I ran this command DBCC SHRINKFILE('xyz', 80000). This is running now for almost two hours. Would anyone know why it is taking so long? Can I cancel this
command without any side effects?
Thanks in advance
View Complete Post