How do I backup a local SQL Server database in XP?

I have developed an ASP.NET 3.5 website on my PC

To deploy the database on the host I use, they require I "restore" it, using a backup of the database.

How do I create this back up of my the database on my PC running XP?

Is there any way to do this in Visual Web Developer? I also downloaded the SQL Server Configuration Manager but I see no option for a backup.

Any help is appreciated!

(Visual Web Developer Express with SQL Server Express 2005)

Thank You.

EDIT

My solution t开发者_JAVA百科hanks to the answers below:

Right in Visual Web Developer Express SQL pane I executed the statement -

BACKUP DATABASE [C:\Mysite\App_Data\ASPNETDB.MDF] TO DISK = N'C:\Backup.bak' WITH NOFORMAT, NOINIT, NAME = N'YourDB-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD, STATS = 10;

This created the back up, with some warnings, not really sure what they meant as it mentioned "missing columns" that I am not familiar with. After uploading the database on the host it looked like everything was there, I will be able to test it soon an will update if there is anything I did wrong or missed.

You should be able to do it through the GUI in management studio or adust the following script and run.

BACKUP DATABASE [YourDB] TO  DISK = N'C:\Backup.bak' WITH NOFORMAT, NOINIT,  
NAME = N'YourDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

It is particularly likely that you will need to adjust the file path to somewhere that the service account has permissions to write to (The Backup folder in your MSSQL directory is a good bet).

Get SQL Server Management Studio 2008 R2 (choose Management Tools only) if you don't have it. It will help you manage your database. The UI is easy to drive - expand the tree on the left to the database required, and right-click -> Backup Database