Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in questions - 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
20 views



Related Hot Questions



Government Jobs Opening


...