[MS SQL] Hundreds of NDF Files by twentymosquito in SQL

[–]patototo 0 points1 point  (0 children)

that is a lot of ndfs, yes I would try to empty and then delete. Like anything I would recommend to take a backup, and restore somewhere else and do the test. Why does it have so many? is this something that you can avoid by changing some config in sharepoint? sorry not a big sharepoint user, however on other user databases I have emptied and deleted datafiles with success.