A colleague of mine reported that an hour after starting a restore the operation failed because the server ran out of disk space. He mentioned that since we are using filestream the size isn't included in the backup size.
Does this sound right? I thought the first thing sql server did up on restoring was to check the amount of disk necessary [including filestream objects] then reserve the space on disk, start initializing the allocated disk space and finally write out the data. I didn't think it was possible to run out of disk space mid-restore.
Does any of this sound right? Does anyone know of a reason the restore would fail halfway through?