copyind db to CD

Hi
Can anyone tell me how to copy my db to a CD ?
ThanksBackup your database and copy the backup file to the CD.

Copyind data from one database table to other

hi all
i have two databases on two different machines.
both databses r having same names.
i want to copy data from the table in other database to table in databse on my machine .
how can i do this.
i will be very thankful to receive help.Take a look at DTS in sql book online. That's the easiest to start with.

copyind data and indexes

Hi everyone!
How can I do to copy the data and the indexes from an existing table on a
database to a new table in another database?
I've tried with select * into base1.table1 from base2.table2, but it only
copy the data and not the indexes.
Can I do it by code? I'm trying to avoid the use of DTS.
Thanks.
Jaime LucciIn Query Analyzer you can auto-script the index for a table and apply
that to the newly created table
HTH,
Gerard|||How can I auto-script the index?
"Gerard" <g.doeswijk@.gmail.com> wrote in message
news:1132151890.279793.213110@.f14g2000cwb.googlegroups.com...
> In Query Analyzer you can auto-script the index for a table and apply
> that to the newly created table
> HTH,
> Gerard
>|||In Query Analyzer: Expand the Indexes folder on the table, select the
index you wish to script and right click on it and the rest will show
it self
NB:
You will have to replace the table name in the created script to apply
it to your other table