Backup Up Remote Database

Our database is on a server provided by the web host. I would like to
backup the data from this database more often than our web host performs
backups. But since our database shares space on its server with other
companies, we are not permitted to use the Enterprise Manager Backup
utility. (The same limitation occurs with the Copy Database Wizard and with
Detach/Attach methods of backing up.)
We considered using DTS to perform the backup on a scheduled basis; we could
copy the database content to a text or Excel file, and then regenerate the
database when it necessary to recover from a lost database. However, DTS
does not completely satisfy our needs, because the structure of the database
(tables and fields) will change occasionally, and we would prefer not to
have to make corresponding changes to the DTS package (and then retest the
package) when this happens. In other words, it would be ideal if DTS could
be used to copy all fields from the database table.
What do other companies do to ensure the integrity of their data without
relying upon the hosting company?Hi
You could create your own scheduled job that runs the T-SQL backup command!
Jasper's expressmaint procedure does this an more!
http://www.sqldbatips.com/showcode.asp?ID=26
John
"Hondo" wrote:

> Our database is on a server provided by the web host. I would like to
> backup the data from this database more often than our web host performs
> backups. But since our database shares space on its server with other
> companies, we are not permitted to use the Enterprise Manager Backup
> utility. (The same limitation occurs with the Copy Database Wizard and wi
th
> Detach/Attach methods of backing up.)
> We considered using DTS to perform the backup on a scheduled basis; we cou
ld
> copy the database content to a text or Excel file, and then regenerate the
> database when it necessary to recover from a lost database. However, DTS
> does not completely satisfy our needs, because the structure of the databa
se
> (tables and fields) will change occasionally, and we would prefer not to
> have to make corresponding changes to the DTS package (and then retest the
> package) when this happens. In other words, it would be ideal if DTS coul
d
> be used to copy all fields from the database table.
> What do other companies do to ensure the integrity of their data without
> relying upon the hosting company?
>
>