Pastel backup

[blue-eye-boy]

I'm very new to pastel, and still learning all the ropes with it. I dont want to use it for accounting, thats what the office ladies are there for, I use it for product reports, that kind of thing. But I want to learn how the program works, settings and so on, so now here I start, with I thing the most important thing, backup.

Someone showed me how to make backups using the sqlserver program that comes with it. But I want to know if there isn't a automated way of doing it? say I set it to backup every day at 6. Then as explained in another thread, that backup files will be backed up on external hdd, with a backup program.

Ideas?

 

[ponder]

Dunno if rsync is available for windows but I would just sync any of the apps associated folders.

 

[guest2013-1]

It depends what version / flavor of Pastel you're running. You mentioned a sqlserver program, so I'm assuming it's Pastel Evolution.

You could download and install (if it's not already on the server) SQL Server Management Studio. In it you can schedule "jobs" to run, specifically for backup purposes. Then all you'd need is a little "bat" file to copy over those files (after it's backed up, which you can also run through SQL if you so desired), to the external drive.

I suggest you might contact a Technican. He can set it all up for you in an hour or so, it's well worth spending the R400 it'll cost to do so.

Now, if you're NOT running Evolution, then I'm not sure what this sqlserver program is you talk about, because Pastel Accounting has always used file-based databases, which is easy to backup, copy/paste files.

rsync is available for Windows, but a pain to get going IMO, nothing good old Dos 3.2 skills can't do in a little .bat file

 

[blue-eye-boy]

It depends what version / flavor of Pastel you're running. You mentioned a sqlserver program, so I'm assuming it's Pastel Evolution.

You could download and install (if it's not already on the server) SQL Server Management Studio. In it you can schedule "jobs" to run, specifically for backup purposes. Then all you'd need is a little "bat" file to copy over those files (after it's backed up, which you can also run through SQL if you so desired), to the external drive.

I suggest you might contact a Technican. He can set it all up for you in an hour or so, it's well worth spending the R400 it'll cost to do so.

Now, if you're NOT running Evolution, then I'm not sure what this sqlserver program is you talk about, because Pastel Accounting has always used file-based databases, which is easy to backup, copy/paste files.

rsync is available for Windows, but a pain to get going IMO, nothing good old Dos 3.2 skills can't do in a little .bat file

Yes it is evolution, version 6.8, and the sql pogram is the 2008 version, saw that yeaterday when I backed up. So say I can schedule jobs, will check that out tomorrow when at work. But what "bat" file are you mentioning?

 

[guest2013-1]

Yes it is evolution, version 6.8, and the sql pogram is the 2008 version, saw that yeaterday when I backed up. So say I can schedule jobs, will check that out tomorrow when at work. But what "bat" file are you mentioning?

I've been working on PC's since DOS. Bat files are just commands you can use in the command prompt that does things for you, like create directories/sort files/move/copy etc etc etc. You can schedule bat files to run through the scheduler, but since you can't predict when a sql backup will finish, you can make it part of the job. Ideally you'd write a sql stored procedure that kicks off the backup process (sql is command lines all the way, so you can do anything with it really) and right after that use shell exec to kick off the bat file that'll copy those files for you.

You have some googling to do in the morning

 

[blue-eye-boy]

I've been working on PC's since DOS. Bat files are just commands you can use in the command prompt that does things for you, like create directories/sort files/move/copy etc etc etc. You can schedule bat files to run through the scheduler, but since you can't predict when a sql backup will finish, you can make it part of the job. Ideally you'd write a sql stored procedure that kicks off the backup process (sql is command lines all the way, so you can do anything with it really) and right after that use shell exec to kick off the bat file that'll copy those files for you.

You have some googling to do in the morning

Thanks, will check it out.

 

[LazyLion]

I use this.... http://allwaysync.com/

Then I install Drop Box and 4Shared.

Then I configure that Allway Sync to backup regularly to the Drop Box folder and it gets uploaded to the Drop Box Cloud.
You can configure it for multiple jobs at any intervals.