This came up when running some numbers on the hard science possibilities of interstellar colonization and I mostly want to know whether I made some major errors and am off by a few orders of magnitude somewhere.
First, assuming the speed of light is an absolute bound, any possible space ship needs to be completely autark, that is have everything it and its passengers will ever need on board. So it needs to be pretty big. I will just assume a cube of 10km edge length. Putting a density of 1 (high density building material filled with air) this gives a mass of $10^{12}$ tons.
Second, if you want to get to any other stars within human life spans you need a speed that is a decent proportion of the speed of light, say $0.5c$.
To compute the fuel needs to accelerate $10^{12}$ tons to $0.5c$ (and then decelerate to zero again) we use the rocket equation, for example here. An exhaust velocity of $1c$ and a target speed of $0.5c$ gives us that we need approximately as much fuel as the mass we want to accelerate (the calculator gives $40\%$ fuel and $60\%$ ship weight).
To achieve an exhaust velocity of $1c$ we will use an antimatter drive. The antimatter will be made from the energy from our sun. The total energy output of the sun corresponds to converting $4*10^6$ tons of matter to energy per second. So if one is able to capture the entire energy output of the sun, one would need about $10^{12}/(4*10^6)=2.5*10^5$ seconds or around 7 hours.
Meaning in summary accelerating a single ship of this size to around half the speed of light would already take the complete energy output of our sun for a several hours assuming $100\%$ perfect efficiency in every step. So we are talking a full Dyson sphere, not just some large solar sails. Does that make sense of did I miss something major somewhere?
Edit (in response to comments): I was indeed thinking of a fully self sustaining colony ship and that does require millions of people on there. The entire computation is also linear in the mass, so if you are interested in the numbers for a smaller ship, you can simple divide the needed energy by the same factor that you reduce the mass. Similary $100\%$ efficiency is easiest to look at because one can account for lower efficiency by simply multiplying in whatever efficiency one wants to use.