What do you use or recommend to backup databases such as in RMS?

We backup to a flash drive that can be taken home. We used to backup to CD. you really dont need a huge backup system for a single store.

Before I answer those questions I would need you to answer these questions.

How many items do you have? How long have you been running RMS? What Version RMS? Do you have a lot of matrix items? Do you track customers?

I ask this because that will cover and idea of how large your DB might be.

I'm running on version 2.0. I've been running it since August 2007. I have about 1500-2000 items. I don't have many matrix or lot matrix items. And I don't track customers.

Thanks.

"Maurice @ ARS" wrote:

A 2gig Flash drive should work for quite a while. I would assume your DB is probably less than 100 Megs. If you have any Custom Reports or Labels be sure to backup the reports and labels DIR once a month to.

Maurice

Another option is to automate the backup using a .bat file and windows task scheduler. Create a seperate .bat file for each day of the week, backup to a directory on your hard drive and then copy it to an external hard drive or a flash drive. If you have a network setup you could copy it to another computer on the network if that works better for you. The advantage of an external drive is that you can swap it out and take copies home with you to protect in event of a fire. I don't have the script on me right now, but if you would like I can post it tomorrow so you can take a look at it. Once you have the script it's pretty easy to setup and you'll never forget to backup. :-) Craig

Thanks you two!!!

"Craig" wrote:

What about encrypting your backup data on your flash drive? So that you provide due diligence to your customer and business data. You can also zip/tar your data - the database compresses very well and would save you alot of space on your flash drive.

I'm looking for recommendations on a good backup system. Thanks!

A 2gig Flash drive should work for quite a while. I would assume your DB is probably less than 100 Megs. If you have any Custom Reports or Labels be sure to backup the reports and labels DIR once a month to.

Maurice

Dear Wesley et al,

This is exactly what I need. I am sooo close but the script, as I've interepreted is falling over. This is the error that I get:

C:\>osql -U XX -P XXXX -S XXXXXXXXX -Q "BACKUP DATABASE 100_XXXXXX TO DISK = 'C:\current.bck'WITH FORMAT, STATS" Msg 102, Level 15, State 1, Server XXXXXXXXX, Line 1 Incorrect syntax near '100'. Msg 319, Level 15, State 1, Server XXXXXXXXX, Line 1 Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

Any help pointing out what I've done wrong would be appreciated.

The script is as follows:

osql -U XX -P XXXX -S XXXXXXXXX -Q "BACKUP DATABASE 100_XXXXX TO DISK 'e:\current.bck'WITH FORMAT, STATS"

Ryan

Wesley Sanders wrote:

Just an update on my earlier question, changing the name of my database to not include an _ (underscore) would seem to have solved the problem.

I now have backups running beeeeeeautifully.

So thank you for the person that originally supplied the script.

Ryan

Ryan Faught wrote: