Timeline for DBCC Shrinkfile not working on SQL 2016
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 11, 2020 at 14:40 | comment | added | Aaron Bertrand |
While you might be able to skip the EMPTYFILE operation for the last file if the file is already "empty" (though I haven't tested this), you should not get this specific error message just because the file happens to be the last file in the filegroup. You would only get the error message if it is the last file in the filegroup and there is something left to move.
|
|
| Jun 11, 2020 at 13:41 | history | answered | Dominique Boucher | CC BY-SA 4.0 |