Looking to copy from hosted server to sqlserver express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cowznofsky - 29 Dec 2007 20:20 GMT

We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.

I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.

I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.

Is there a simple way to do this on my own, or will I be calling the
hosting company?

Reply to this Message

John Bell - 29 Dec 2007 21:19 GMT

Hi

Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.

John

> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
[quoted text clipped - 8 lines]
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?

Reply to this Message