|
| 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?
|
|