possible to copy database with Tsql or SP?

Hello,
I need to create a copy of a Sql Server database. Is it possible to do this
using Tsql or is there an SP(s) for doing this? Do I need to use replicatio
n
for this?
Thanks,
RichEasy way would be to do either: 1) Import and Export Wizard, or 2) Backup
and restore. You could also detach the database files, copy them and attach
them.
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E6825188-5EB1-4942-BF74-6904EF51E741@.microsoft.com...
> Hello,
> I need to create a copy of a Sql Server database. Is it possible to do
> this
> using Tsql or is there an SP(s) for doing this? Do I need to use
> replication
> for this?
> Thanks,
> Rich|||There is also a copy database wizard in the list of wizards (I'm assuming
you are talking about SQL 2000)
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E6825188-5EB1-4942-BF74-6904EF51E741@.microsoft.com...
> Hello,
> I need to create a copy of a Sql Server database. Is it possible to do
> this
> using Tsql or is there an SP(s) for doing this? Do I need to use
> replication
> for this?
> Thanks,
> Rich