Backup:
*********

1) Open the SQL Server Enterprise Manager.
2) Click on "Microsoft SQL Servers" in left pane.
3) Expand your server group.
4) Click on "Databases".
5) Right click in the database for which you wish to take backup.
6) Click on "All Tasks" > "Backup Database". A new backup window will appear.
7) Select "Database-Complete" option.
8) Click on "Add" button in destination frame. A new window appears for selecting backup destination.
9) Select "Filename" option.
10) Enter Path where you wish to save backup along with the file name of the backup set. Please specify extension ".bak" for file name of the backup set.
11) Click "OK" twise.
12) A progress indicatior will show backup progress.


Restore:
*********
Login to the SQL server,
choose and run Enterprise Manager.
Select the database onto which you would like to restore the data,
right click on the database,
select 'Restore database' from under the 'All tasks' menu.
Under the 'General' tab, select 'From Device'.
From under the 'parameters' section, click 'select device'.
From the dialog box that appears, select 'add'. Browse to the .BAK file using the option under 'File'.
Select 'OK' across all sub options and finally the main dialog box to perform the restore operation.

thanks for this article

Hi,

I have SQL Server Express 2000 that comes with plesk,How can i REstore databases that comes from other servers?
Is There any way for that.

also remember sql2000 backups don't get restored in sql2005.

thanks for this. much appreciated :D

If you use a user other than the default sa and the login on the two servers do not match, the restore will break the login and you will need to re-assign the permissions on the database you are restoring to.

Thanks for the article

@enterhost_dustin That is a good reason to backup the Master database!

So to add to the first post: it's a great idea to backup the Master db in addition to whatever db you're backing up, especially if you need to restore the db to a new database server which doesn't have the permissions (which are contained in the master db) from the old server.