SQL Server - Defunct Filegroup and Defunct Data File This is an off-site link.  Please review our Terms of Service for additional information.

(Travis Gan) A data file becomes DEFUNCT when its respective filegroup is removed or when the data file or its filegroup is not included during the piecemeal restore in simple recovery model. Usually a filegroup can not be removed if the data file is not empty.

Read this article...

comments powered by Disqus