How to create backup then restore with an MS SQL database?

Can somebody please tell me how to go about creating a backup file of a MS SQL database, then import it into another server?

OK


Open your enterprise manager.

Part A - Backup database:

Right click on the database you want to backup
select "All task"
select "backup database"
In the Destination block click "add"
select the destination you want ot backup the database to.
(usually a .bak file will be created)

Part B - Restore Database:

now be sure to have the file just created above available on the server you want to retore the DB to.
In Enterprise Manager... right click on Databases and "add database"
Give the name you want for this database
Right click on new database
select "All tasks"
select "Restore Database"
Click "From Device"
CLick "Select Device" button
Click "Add"
Select the file created in part A
Press Ok

Should work...

Thank you!