Backing up remote SQL Server

I have written a SQL DB, and ASP.NET website for a client. The clients
database and webpage are not inhouse but on a hosting provider.
This provider says they only backup for disastor purposes--which didn't make
me feel to good.
So my question...
How can I help this non-techie client to backup her remote SQL Server
Database regularly?
What is the best means of doing this?
Some software for her--again figure very low tech small business--no IT
department'
Some other service to do it?
Thanks,
ShaneWrite one or a few ASPI.NET pages from which the user does backups. From
here you can use .ExecuteNonQuery and execute the appropriate BACKUP
DATABASE command. Note that the backup file will be created from the SQL
Server machine's perspective.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
news:%233WRgI5BEHA.3748@.tk2msftngp13.phx.gbl...
> I have written a SQL DB, and ASP.NET website for a client. The clients
> database and webpage are not inhouse but on a hosting provider.
> This provider says they only backup for disastor purposes--which didn't
make
> me feel to good.
> So my question...
> How can I help this non-techie client to backup her remote SQL Server
> Database regularly?
> What is the best means of doing this?
> Some software for her--again figure very low tech small business--no IT
> department'
> Some other service to do it?
> Thanks,
> Shane
>|||ok...
But where does that file reside?
If still no hosting site that isn't much of a backup.
Are you saying try to backup to a local protected directory, download the
backup file and in case of disaster client sends that backup file to people
on host site to restore?
Thanks,
Shane
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Jy4hi5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Write one or a few ASPI.NET pages from which the user does backups. From
> here you can use .ExecuteNonQuery and execute the appropriate BACKUP
> DATABASE command. Note that the backup file will be created from the SQL
> Server machine's perspective.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
> news:%233WRgI5BEHA.3748@.tk2msftngp13.phx.gbl...
> make
>|||SQL Server does the backup, regardless of who submits the backup command.
Backup on C:\ and it is on C:\ on the SQL Server machine. You can then FTP
down the backup file or do whatever you want with it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
news:%235k0gt5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
> ok...
> But where does that file reside?
> If still no hosting site that isn't much of a backup.
> Are you saying try to backup to a local protected directory, download the
> backup file and in case of disaster client sends that backup file to
people
> on host site to restore?
> Thanks,
> Shane
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:%23Jy4hi5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
clients
didn't
IT
>|||Ok. Thanks.
My client isn't too good at even FTP, so I would have to some how provide a
secure link I suppose. Thanks for the reply.
Shane
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtLfke6BEHA.916@.tk2msftngp13.phx.gbl...
> SQL Server does the backup, regardless of who submits the backup command.
> Backup on C:\ and it is on C:\ on the SQL Server machine. You can then FTP
> down the backup file or do whatever you want with it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
> news:%235k0gt5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
the
> people
> in
From
SQL
message
> clients
> didn't
Server
> IT
>