I have database with 263GB where free space is about 45GB. By using below query I executed the shrinking activity.
Code:
USE [BriggsAX]
GO
DBCC SHRINKFILE (N'BriggsAX' , 250876)
GO
but I got the following error after 2 and half hours. Can you please suggest how I can resolve this issue.
Code:
Msg 3140, Level 16, State 3, Line 1
Could not adjust the space allocation for file 'dbfile_Dat'.
DBCC execution
...