Orphaned Database File

[aachaemenes]

DBADASH does not track orphaned database files. When databases are detached sometimes DBAs forget to delete them later. This check should let DBA know that there are orphaned database files.

[DavidWiseman]

Thanks for the suggestion. I don't think there is an easy way to detect orphaned files from T-SQL. Scanning the file system for database files that are not attached is possible but quite expensive. Not sure if this would be possible remotely or not. I'm unlikely to add this feature.

[aachaemenes]

Dbachecks powershell module has orphaned files check to do that

…

On Thu, Oct 10, 2024, 2:16 PM David Wiseman ***@***.***> wrote: Thanks for the suggestion. I don't think there is an easy way to detect orphaned files from T-SQL. Scanning the file system for database files that are not attached is possible but quite expensive. Not sure if this would be possible remotely or not. I'm unlikely to add this feature. — Reply to this email directly, view it on GitHub <#1066 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BGN5RXZTZPO6QHIPJNRXSPLZ23VELAVCNFSM6AAAAABPXEMEHCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBWGA2TGMBZHE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[DavidWiseman]

It looks like that is using Find-DbaOrphanedFile.