Database corruption - Multi file a better solution??
Today we discovered that our file is corrupted. Somehow there are scripts in the database, that cannot be deleted. Each time we try to, we get the message "Script cannot be be found".
Our file is pretty big, and restoring a backup, that has been made 7 days ago, is not an option. That would take to much time. Our file has around 150-200 TOs.
Now we are thinking to split the file into several files. Creating a multifile solution.
This way, we hope that a corruption will not hit the whole solution.
I checked out the seperation model asswell. I like the Interface idea.
But speaking of file corruption, is a multifile solution a good approch?