You can do this by 2 ways. One is backup-and-restore and other is generating script. For your requirement, script based method should be used. Once you generate the script which is pure SQL statements, you can send the script to the machine where you want to clone. So I will provide you a link where you can find a tutorial for the same.
Raaj KumarPosted Feb 28, 2010, 11:23 PM
You can do this by 2 ways. One is backup-and-restore and other is generating script. For your requirement, script based method should be used. Once you generate the script which is pure SQL statements, you can send the script to the machine where you want to clone. So I will provide you a link where you can find a tutorial for the same.
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
Regards,
raaj