DataBase Backup

Hi,

I am using one database to store some information, which is now in my local system.Now i want to create a copy of the database, which is in my system to another system (including the data in the table's and the stored procedures i have created).

Is this possible. if yes please help

Thanks in advance....

If you want to use the database with data then you can RESTORE this A database with a new name.

If not you can script this database with all objects and use the same script to create another database with new name.

Refer to books online for RESTORE and SCRIPT for more information.