Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp