Organizational Research By

Surprising Reserch Topic

Question:Handle SQL FILESTREAM Data Corruption and Backup


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?

 


asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
37 views



Related Hot Questions

2 Answers

0 votes
If you care about the data -- as you apparently do, based on the question -- then why putz around? Declare a BLOB column in your database and let the DBMS deal with the issues you raise.

Someone, perhaps someone on your team, may object that's too slow. First, I challenge that assumption. Second, if it's tested and it's too slow, do it anyway (!) and keep the FILESTREAM version as an external cache. That way dump/restore can ignore it, and corruption/deletion can be rectified with one SELECT statement.
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013
0 votes
If you care about the data -- as you apparently do, based on the question -- then why putz around? Declare a BLOB column in your database and let the DBMS deal with the issues you raise.

Someone, perhaps someone on your team, may object that's too slow. First, I challenge that assumption. Second, if it's tested and it's too slow, do it anyway (!) and keep the FILESTREAM version as an external cache. That way dump/restore can ignore it, and corruption/deletion can be rectified with one SELECT statement.
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...