This is very recent post i have read SQL Server will not delete mdf and ldf files if database is Offline state.
This Problem has been observed in case of recovering database and action performed to delete database which are Offline. So after deleting off line database one have to manually delete the mdf and ldf file from filesystem in order to recover the space.
Is it safe to delete orphan mdf , ldf filesfrom file system if no database exists.
Answer is Yes it is safe to delete files.
No comments:
Post a Comment