Copy database between servers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Copy database between servers

Author

Topic

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2007-12-09 : 10:07:27

Hi,

I've got two servers with sql 2005 express on, the first is a shared server at our isp, we rent one database from them. The other server is our own and we have full sa access.

Is there an easy way to copy the database from the shared server onto our own server. We're unable to use the backup.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-09 : 17:51:53

Don't know whatelse you can do. Can you bcp data out and copy to your server?