There is no manual save option. Skyward Sword uses an automatic checkpoint system exclusively.
Progress since the last checkpoint (usually < 5–10 minutes of gameplay). You won't lose items, rupees, or dungeon progress—just need to re-walk from the last statue/transition.
The system is generous—checkpoints are frequent. Just don't quit mid-dungeon without hitting a statue.