automatic backup

you can use windows scheduled task or sql server agent..

cod

Jeff has been kind enough to send me a couple of batch files that work really well, one for version 1.3 and the other is for 2.0. The commands in MSDE for version 1.3 and the commands in SQL Express used in Version 2.0 are different. Then you can run your batch using the Task Scheduler. If you need the batch files, email me and I will send them to you. As I stated, these are not original by me, but were written by Jeff Hobbs and they work well.

Regards,

Kinnard

Kinnard L. Kohler Retail Management Systems of Arkansas

300 South Rodney Parham Road Parham Place - Suite 1 Little Rock, AR 72205-4747 (Tel) 501-412-5686 (Fax) 501-374-3636 Email: snipped-for-privacy@sbcglobal.net

"cod" wrote:

You bet, this answer is from something that was posted here quite some time ago with a minor tweak for me to get it working for my system. Save the following to a text file and call it 'backup.bat':

osql -U userid -P password -S SERVERNAME -Q "BACKUP DATABASE DATABASENAME TO DISK = 'c:\Backups\current.bck'WITH FORMAT, STATS"

Change userid to your userid (such as sa), password to your password, SERVERNAME to your Server and DATABASENAME to the name of your database.

Then change the location of your backup to wherever you want to save it to.

Schedule the backups with Task Scheduler for as often as you'd like.

I backup every second hour for 12 hours of the day. On the alternate hour that I'm not backing up, Winzip runs a job that compresses the file and renames if for me with the timestamp appended to the filename. Then, at 10pm, the latest file then gets uploaded via secureftp to another server offsite.

My database is currently 568,467kb when backuped, this compresses to 171,690kb.

Hope this helps and kudos to those that helped me set this up a while back.

Sincerely,

Ryan