I am currently developing a client-server system using visual basic and sql
server. I need to know how i can install SQL server on the client machine
without having to install all components (such as enterprise manager) and
still be able to backup, restore and configure the database on the client
machine. I only need the core sql sever components. How can i still configure
the database with minimal installed components?

The reason for having sql server on both client and server is that the server
is remote and connection can be lost between them. The client machine is
obviously smaller in memory so having all the extra components installed
will slow it down.

Can any one help?

Thanks