I know shrinking data files are not good, but sometimes we have to do it when we have some space issue. I don't do this on a regular basis but when i tried shrinking the data files i got his error below: any idea???
Shrink failed for Datafile 'IBM_Core_1'. (Microsoft.Sqlserver.smo)
An expception occured while executing a Transact-SQL statement or batch.
A server error occured on the current command. The results, if any, should be discarded.
File ID 6 of Database ID 2 cannot be shrunk as it is either being shrunk by another process or is empty. (Microsoft SQL Server)