making a local copy

hi I have a SQL DB hosted in a hosting company, I want to create a local copy
in my pc, what is the best way to do it.
I tried to make a backup but it seem that the backup can be done only in the
Hosting machine so I could not do it.
thks
Ken
Your best bet is to have them send you a copy of the latest full backup.
Maybe they have an FTP site where you can access it.
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||I use DTS to copy the db from a web host to a local SQL Server. You're
right, backup requires the server to have access to the drive where you
store the backup file, and it can't get to your computer.
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
|||Hi
You may want to talk to the hosting company to make the backup downloadable
or have it ftp'd (with the appropriate security in place).
John
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||Thks all of you!!!
"Kenny M." wrote:

> hi I have a SQL DB hosted in a hosting company, I want to create a local copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken