Skip to content

Instantly share code, notes, and snippets.

@haroldcris

haroldcris/Clear SQL Data File

Created September 17, 2020 21:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save haroldcris/7e2c1304d9a278515fa421178f135ccb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save haroldcris/7e2c1304d9a278515fa421178f135ccb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Clear SQL Data File
-- Run before deleting .ndf file that causes error
-- DBCC showfilestats
DBCC ShrinkFile($LogicalFilename, EMPTYFILE)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment