if you have MS Access, compacting the database will create a backup for you. but a backup is no good unless you download it and store it somewhere different than your host server.
I have tried this one and it does 95% of the backup but I noticed some structure errors like an integer field with a size attribute of something like 76263723592. But most of the dump looked very good. Now it needs to be cleaned up and a reload script would be required to restore the db.
Yes, but sometimes just before you want to upgrade the tables for MOD, you will need to backup in case and I sick of the enterprise manager. There's got to be a easier way.
In SQL Server, you could create a dts package to backup the db, create a stored proc to execute the dts package and create an ASP page to call the stored proc
Topic Locked
Posted - 29 May 2003 : 04:44:40
