This article by Michael Brent Collings, found on the LDS Publisher site, is great for authors who need to find perspective in the writing career.
Instead of trying to be a successful author, think of what makes you happy about writing. Why are you really doing it?
For me it's discovering where these stories lead and sharing them with others. Period. When I think of it this way, it removes the stress and helps me focus on creating the story.