Deploying Website w/SQL Server backend?

I am new to Web development and database deployment. If I'm using a SQL Server DB for a website...how do I deploy the SQLDB to another server where the Web app resides. I know when using Access, you can move the DB to where the web app is located.

Thanks,

This is a handy tool.

http://sqldump.sourceforge.net/

Basically you would need to do a dump of your table/database and then load it onto the appropriate server.