Spoiler..
*
*
*
*
*
*
*
*
*
*
*
*
Its very near the end of the game(cant miss the spot where you get it). You get it handed over by a demon, no fight, no quarrel, he simply bows to your great power
And it *is* a very nice sword, too bad you cant use it for long in SoA.