Backup Location

Hi,
Our web site's SQL Server is hosted by another company in internet. I want
to backup our database but the backupsets will be created on the host. Is it
possible to create a device the way that backupsets be created on my local
SQL Server?
Any help would be greatly appreciated.
Leila
No, SQL server will not "push" the data to the client machine from where you execute the backup.
Perhaps you can FTP the file after performing the backup?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leila" <Leilas@.hotpop.com> wrote in message news:%23lnZYDg3EHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Our web site's SQL Server is hosted by another company in internet. I want
> to backup our database but the backupsets will be created on the host. Is it
> possible to create a device the way that backupsets be created on my local
> SQL Server?
> Any help would be greatly appreciated.
> Leila
>