Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Checking if a backup was good or not |
Mon, May 26 2014 5:25 AM | Permanent Link |
Matthew Jones | I'm using the BACKUP DATABASE SQL to backup the tables. It runs fine,
but the database.Execute() function returns 0 rows affected. What is the proper way to determine if the backup was all good or not. I'd hate to find it was reporting an error and I was missing it. I can of course check that there is a file created, but what if it was only half complete? -- Matthew Jones |
Mon, May 26 2014 8:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
Where I've used it I've just assumed that if it hasn't crashed its worked. I know you get a message in EDBManager so you could have a look in there and see what Tim does. As always with a backup the only real test is RESTORE Roy Lambert |
Mon, May 26 2014 10:01 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> As always with a backup the only real test is RESTORE Hmm, restore, good point. I should practice that... -- Matthew Jones |
Mon, May 26 2014 11:44 AM | Permanent Link |
Raul Team Elevate | On 5/26/2014 5:25 AM, Matthew Jones wrote:
> I'm using the BACKUP DATABASE SQL to backup the tables. It runs fine, > but the database.Execute() function returns 0 rows affected. What is > the proper way to determine if the backup was all good or not. I'd hate > to find it was reporting an error and I was missing it. I can of course > check that there is a file created, but what if it was only half > complete? > There should be OnProgress and OnStatusMessage messages generated while backup runs as well as exception thrown if fails (i believe). Also once it's done you can use the "set backup store" and query the "Backups" table in the config DB. Of course test restore is the only real test. Raul |
Tue, May 27 2014 3:17 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Raul
>Of course test restore is the only real test. That's a lesson I learned a short while ago (say 20 years) just after I started out in recruitment. I built my own system (AP/DOS) and decided I wanted to make sure I was safe. Bought a nice tape drive, backed up and verified every night using grandfather/father/son approach. First time I needed to restore none of the tapes worked. Roy |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |