SQL Server 2008 has no true load balancing, meaning having multiple database servers actively updating the same database.

There are possible ways to off load specific tasks to other servers. For example, replicate data to another server, and run reporting on that server.