- Posts: 10
- Thank you received: 0
Backup and Restoring
11 years 11 months ago #4126
by Gardener
Backup and Restoring was created by Gardener
Hi Guys,
running Advanced ETL Processor Ent V4.2.7.2. I am trying to backup the repository on one machine and restore it to another. The second machine is identical to the first apart from different folder structure. When I restore the repository from the first to the second machine the second machine displays some very odd attributes. The scheduler does not display the correct start date and then runs the job from the incorrectly displayed start date. Can the packages be backed up independently of the repository.
Thanks
running Advanced ETL Processor Ent V4.2.7.2. I am trying to backup the repository on one machine and restore it to another. The second machine is identical to the first apart from different folder structure. When I restore the repository from the first to the second machine the second machine displays some very odd attributes. The scheduler does not display the correct start date and then runs the job from the incorrectly displayed start date. Can the packages be backed up independently of the repository.
Thanks
Please Log in or Create an account to join the conversation.
11 years 11 months ago #4127
by admin
Mike
ETL Architect
Replied by admin on topic Re: Backup and Restoring
What is your repository type?
When I restore the repository from the first to the second machine the second machine displays some very odd attributes.
Post your screenshots here please (compress them if they are too big)
How did you back up the repository?
Can the packages be backed up independently of the repository.
Not at the moment
Mike
When I restore the repository from the first to the second machine the second machine displays some very odd attributes.
Post your screenshots here please (compress them if they are too big)
How did you back up the repository?
Can the packages be backed up independently of the repository.
Not at the moment
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
11 years 10 months ago #4129
by Gardener
Replied by Gardener on topic Re: Backup and Restoring
HI
attached screen shots .
etlschedule
Please note the Start At Column, dated 2009, if I make any other amendment the date drops back further. Jobs immediately kick off presumably because they are running daily from 2009?
On machine B I have created new packages but have copied the jobs from the old package to the new. I have then deleted the old package and all schedules and recreated with the same problems.
Is there any chance that all the steps in the package can be restored to machine B without the package or repository?
attached screen shots .
etlschedule
Please note the Start At Column, dated 2009, if I make any other amendment the date drops back further. Jobs immediately kick off presumably because they are running daily from 2009?
On machine B I have created new packages but have copied the jobs from the old package to the new. I have then deleted the old package and all schedules and recreated with the same problems.
Is there any chance that all the steps in the package can be restored to machine B without the package or repository?
Attachments:
Please Log in or Create an account to join the conversation.
11 years 10 months ago #4130
by Gardener
Replied by Gardener on topic Re: Backup and Restoring
"what is your repository type"
sorry don't know what that refers to?
Default Repository (MS Access) is this what you were after?
Thanks
sorry don't know what that refers to?
Default Repository (MS Access) is this what you were after?
Thanks
Please Log in or Create an account to join the conversation.
11 years 10 months ago #4132
by admin
Mike
ETL Architect
Replied by admin on topic Re: Backup and Restoring
Hello
I think I sort of understand what the problem now.
If it is actually the problem
This date is automatically updated once the execution is completed
It is set before the current date when you modify or update the schedule.
If you want to modify the start date click advanced and change it there
Mike
I think I sort of understand what the problem now.
If it is actually the problem
This date is automatically updated once the execution is completed
It is set before the current date when you modify or update the schedule.
If you want to modify the start date click advanced and change it there
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
11 years 10 months ago #4133
by Gardener
Replied by Gardener on topic Re: Backup and Restoring
Hi,
I have just gone back to the scheduler > Advanced > Select today's date, the start at date is now correct.
Sorry for lack of info, ETL was upgraded from an earlier version, first time I upgraded over the top of the old version, second time uninstalled, reinstalled re-booted. I can't explain now why the scheduler appears to be working.
Previously every time I go into the scheduler > Advanced > Select todays date, the start at date in scheduler drops back a couple of years every time you edit the scheduler.
Can you confirm a:) That backing up and restoring repository to a different machine is a supported function
b:) Upgrade can be performed over the top of existing versions, un-install AETLAGENT first?
Many Thanks
I have just gone back to the scheduler > Advanced > Select today's date, the start at date is now correct.
Sorry for lack of info, ETL was upgraded from an earlier version, first time I upgraded over the top of the old version, second time uninstalled, reinstalled re-booted. I can't explain now why the scheduler appears to be working.
Previously every time I go into the scheduler > Advanced > Select todays date, the start at date in scheduler drops back a couple of years every time you edit the scheduler.
Can you confirm a:) That backing up and restoring repository to a different machine is a supported function
b:) Upgrade can be performed over the top of existing versions, un-install AETLAGENT first?
Many Thanks
Please Log in or Create an account to join the conversation.