Hello, i would like someone to help me in this
I have a filegroup A with file A1 and A2
file A1 have
so is completely full
size of file is 211690MB
my new file A2, is completely free and have auto growth enabled
my objective is, whats the best practice to move data ( extents ) from file A1 to A2 ?
i tried "DBCC SHRINKFILE (N'A1', 211689)" but took so long and gave a strange error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Database is currently operating normally, so i think we can ignore that ?
i just wanted to move data from one file to another
thanks for all your time and help