Backing up my DB on host

Hi,
I can make backup from my database but the SQL Server is on a
host(internet). The backup sets are placed on the host.
How can I create backups the way that backup sets relocate to my local PC.
Any help would be greatly appreciated.
Amin
I doubt that you will be able to do this. In order for it to happen your
SQL Server machine would have to be able to see the hard drives on your
machine. This talks about the database maintenance wizard, but the rules
apply to normal T-SQL backups as well:
http://support.microsoft.com/default...b;en-us;555128
What is your objective? Do you want to get your production data which is
located on the internet onto your machine? How far away from your host are
you? One option (although not a fun one) is driving to your host and
grabbing a tape/CD/DVD containing your backup file. Another option would be
to create a linked server from your PC (or local server) to your remote SQL
Server. You could then perform an INSERT INTO...SELECT (from the linked
server). One final option: Use a tool or script that creates insert
statements for you. you could then issue these statements on your local
machine.
Keith
"Amin Sobati" <amins@.morva.net> wrote in message
news:%23bu4uUxmEHA.2616@.tk2msftngp13.phx.gbl...
> Hi,
> I can make backup from my database but the SQL Server is on a
> host(internet). The backup sets are placed on the host.
> How can I create backups the way that backup sets relocate to my local PC.
> Any help would be greatly appreciated.
> Amin
>
|||Actually, you should be able to do it if they let you run backups. You need
to temporarily open up your computer to the internet and allow guest write
access to a file share on the computer. You can then get the IP address of
your computer and use the following command:
BACKUP DATABASE databasename
TO DISK = '\\10.1.0.1\share$\directory\file.bak'
Does your IP actually let you run backups though? That's kind of scary.
"Keith Kratochvil" wrote:

> I doubt that you will be able to do this. In order for it to happen your
> SQL Server machine would have to be able to see the hard drives on your
> machine. This talks about the database maintenance wizard, but the rules
> apply to normal T-SQL backups as well:
> http://support.microsoft.com/default...b;en-us;555128
> What is your objective? Do you want to get your production data which is
> located on the internet onto your machine? How far away from your host are
> you? One option (although not a fun one) is driving to your host and
> grabbing a tape/CD/DVD containing your backup file. Another option would be
> to create a linked server from your PC (or local server) to your remote SQL
> Server. You could then perform an INSERT INTO...SELECT (from the linked
> server). One final option: Use a tool or script that creates insert
> statements for you. you could then issue these statements on your local
> machine.
> --
> Keith
>
> "Amin Sobati" <amins@.morva.net> wrote in message
> news:%23bu4uUxmEHA.2616@.tk2msftngp13.phx.gbl...
>
|||I can't imagine that the network admins would want to turn off the firewall
or expose a machine on the internet.
If the [client] machine is available (visible) on the internet, then the
T-SQL BACKUP command backing up to the UNC should work (as long as the
account running SQL Server on the remote machine has rights to the share on
your computer). This is described within the KB article.
Keith
"MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
news:45E7E013-C3E6-49BC-98BE-43BC153AD276@.microsoft.com...
> Actually, you should be able to do it if they let you run backups. You
need
> to temporarily open up your computer to the internet and allow guest write
> access to a file share on the computer. You can then get the IP address
of[vbcol=seagreen]
> your computer and use the following command:
> BACKUP DATABASE databasename
> TO DISK = '\\10.1.0.1\share$\directory\file.bak'
> Does your IP actually let you run backups though? That's kind of scary.
> "Keith Kratochvil" wrote:
your[vbcol=seagreen]
rules[vbcol=seagreen]
is[vbcol=seagreen]
are[vbcol=seagreen]
would be[vbcol=seagreen]
SQL[vbcol=seagreen]
linked[vbcol=seagreen]
PC.[vbcol=seagreen]
sql