Very Computer

Hello,

I would like to copy a database from one server to another.
Backup/restore doesn't seem to work.
I have a lot of tables so I don't want to export the tables one by one.
What can I do to copy the database quickly ?

Thanks in advance,

                     Steven

Steven - what error(s) do you get with backup/restore?  You can also use
sp_attach_db and sp_detach_db .....

Quote:> I would like to copy a database from one server to another.
> Backup/restore doesn't seem to work.
> I have a lot of tables so I don't want to export the tables one by one.
> What can I do to copy the database quickly ?

> Thanks in advance,

>                      Steven

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq

Have you tried the DTS Import it will allow you to import objects between
databases

Quote:> Hello,

> I would like to copy a database from one server to another.
> Backup/restore doesn't seem to work.
> I have a lot of tables so I don't want to export the tables one by one.
> What can I do to copy the database quickly ?

> Thanks in advance,

>                      Steven