Reply to thread

Message

<blockquote data-quote="Marcusb" data-source="post: 261492" data-attributes="member: 11550">OK, I made a batch file that should back up the MP database using an OSQL command line query.Just set it to run via a sceduled task once a day and it will back up the database and manage the last five days worth of backups.It's pretty quick and dirty and needs some setting up.I'm not home at the moment, so can't test it, but in theory it should work.I'll fly home tomorrow so should be able to test it myself and post the matching restore files too (home is a long way away).Basically just open the attsached file and make sure you change the file location variables to match what you have and create any required sub folders.Then change the file name extension from txt to bat (since the forum wont allow me to upload batch files.I'll be out of contact for the next day or two, then can make any tweaks as needed.&nbsp; I tested it with a different SQL express database that I have here and it works well, so any issues may just be with the database name, password or file structure, since I'm going from memory.Also, I know I should use &quot;IfExist&quot; before copying or deleting files, but like I said, it's quick and dirty <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Cheers,Marcus.</blockquote>

[QUOTE="Marcusb, post: 261492, member: 11550"] OK, I made a batch file that should back up the MP database using an OSQL command line query. Just set it to run via a sceduled task once a day and it will back up the database and manage the last five days worth of backups. It's pretty quick and dirty and needs some setting up. I'm not home at the moment, so can't test it, but in theory it should work. I'll fly home tomorrow so should be able to test it myself and post the matching restore files too (home is a long way away). Basically just open the attsached file and make sure you change the file location variables to match what you have and create any required sub folders. Then change the file name extension from txt to bat (since the forum wont allow me to upload batch files. I'll be out of contact for the next day or two, then can make any tweaks as needed. I tested it with a different SQL express database that I have here and it works well, so any issues may just be with the database name, password or file structure, since I'm going from memory. Also, I know I should use "IfExist" before copying or deleting files, but like I said, it's quick and dirty :) Cheers, Marcus. [/QUOTE]

Verification