Jump to content


Schedule Backup To Include All Existing Tables

  • Please log in to reply
2 replies to this topic

#1 jrosen1040



  • Members
  • Pip
  • 5 posts

Posted 25 January 2012 - 09:02 PM

Can the scheduled backups be set to include all tables in the database, even those that did not exist at the time the backup job was created? I'm afraid I will forget to change the job as we create new tables and thereby not get the new ones backed up? If this is possible, how do I do it? Thanks!

#2 peterlaursen


    Advanced Member

  • Admin
  • PipPipPip
  • 8,148 posts
  • Gender:Male
  • Location:Skagen, Denmark

Posted 26 January 2012 - 09:25 AM

Well, yes. Please see image.

Attached File  alltables.jpg   42.24KB   12 downloads

In that case the XML-jobfile will read


<tables all="yes">


.. and note that no specific tables are listed. The job will backup the tables (and no other objects) that exist at the time of backup.

Computers make your grey hair come off ....

Peter Laursen

#3 jrosen1040



  • Members
  • Pip
  • 5 posts

Posted 27 January 2012 - 01:42 PM

Thanks! I should have realized that. For some reason I thought it was recording all the table names individually in the xml file.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users