Do you have the 2GB or 4GB card? In general, you can get by fine just turning down some effects. But VRAM usage tends to scale with resolution, and the Rift's >HD render target will probably put the squeeze on a 2GB card.

Even with a 4GB 960, you might run into memory bandwidth issues, but without running the software I'm just speculating.