At work we're going to store media for our clients such as video, HD photos and audio, I suggested using the SQL FILESTREAM to store such media.
One of the main concerns about this approach is what happens if the FILEGROUP gets corrupted?
Would this affect the Database or its functioning?
Will there be any warning the data might be corrupted?
Does backing up a database with corrupted FILEGROUPS raise any warning? Or does it just backup normally?
If a backup can be made with corrupted data, What about the Restore?
Any other concerns we should take into account?