Comments
Sort by recent activity
Eddie,
You misunderstand what I am asking.
The 2 servers are in the acceptance server GUI but one is from development and the other one is the acceptance server. I will upgrade development at least a week before acceptance. I want to delete the development registered server from the acceptance GUI then I will upgrade it. I just want to know what this actually does?
It should only affect the acceptance GUI and not have any effect on the development server I would hope.
Here is the setup currently.
DEV01 has DEV01 in its GUI for registered servers.
ACC01 has both DEV01 and ACC01 in its GUI as registered servers.
I want to remove DEV01 from ACC01 registered servers, upgrade DEV01 and at a later date upgrade ACC01.
Chris / comments
Eddie,
You misunderstand what I am asking.
The 2 servers are in the acceptance server GUI but one is from development and the other one is the acceptance server. I will upgrade development at least...
I have seen similar problems with SQL Agent jobs that run from one day to the next.
This is from my Connect item
I tried to add a new schedule to an existing job. I wanted to run the job from 3.58pm to 4.00pm the next day. I set the Start and End date but when the time passed the Ending at time on the first day the job did not run. I changed the Ending at time to be less than the Starting time ie 3.50pm and the job runs.
Looks like the scheduler is not looking at the End date when the Ending time is after the Starting time.
We are on SQL2005 SP2 build 3282.
I know that you are not quite like this but it is similar. I would change the start and end times to be in the same day.
Chris / comments
I have seen similar problems with SQL Agent jobs that run from one day to the next.
This is from my Connect item
I tried to add a new schedule to an existing job. I wanted to run the job from 3.58p...
This might be a thread error. We do something similar copying backup files to another server to restore them to run DBCC CHECKDB on the restored database.
We got the occasional thread error and had to restrict how many backups we try to restore at any one time.
You might want to adjust the MAXTRANSFERSIZE parameter.
HTH
Chris / comments
This might be a thread error. We do something similar copying backup files to another server to restore them to run DBCC CHECKDB on the restored database.
We got the occasional thread error and had...
As you are using 6.2 what does the Red gate log show? From the GUI right click on Show Log on the failed job.
Chris / comments
As you are using 6.2 what does the Red gate log show? From the GUI right click on Show Log on the failed job.
Chris
Randy,
I raised this issue sometime ago with the SQL2008 Upgrade Advisor and Red gate haven't decided to fix it so far.
I have used 5.1 thru 6.3 on SQL2005 and never had any problems but I have not upgraded from 2000 to 2005.
Chris / comments
Randy,
I raised this issue sometime ago with the SQL2008 Upgrade Advisor and Red gate haven't decided to fix it so far.
I have used 5.1 thru 6.3 on SQL2005 and never had any problems but I have not...
And the partial backup is still there to! I have raised this as an issue that I am hoping will make it to the enxt version. If the backup fails because of space the partial backup should be removed.
Chris / comments
And the partial backup is still there to! I have raised this as an issue that I am hoping will make it to the enxt version. If the backup fails because of space the partial backup should be removed...
The format change is mentioned in the release information.
Chris / comments
The format change is mentioned in the release information.
Chris
Great piece of info Eddie. We run SQL Agent jobs created originally from the GUI using the Script tab. So if my 5.4 script dores not have a THREADCOUNT = parameter and it gets ungraded to 6.? and is run on a mutli core will it default to multiple threads and then need a bigger memory footprint?
Thanks
Chris / comments
Great piece of info Eddie. We run SQL Agent jobs created originally from the GUI using the Script tab. So if my 5.4 script dores not have a THREADCOUNT = parameter and it gets ungraded to 6.? and i...
Petey,
Just what I needed to know. I would have added a THREADCOUNT = 1 to the T-SQL statement in the job just to make sure.
Thanks
Chris / comments
Petey,
Just what I needed to know. I would have added a THREADCOUNT = 1 to the T-SQL statement in the job just to make sure.
Thanks
Chris
Thanks Peter.
I have seen this before. Maybe I am confused here but it mentions:-
When SQL Backup performs a backup using the default settings and one file, it requires a block of free contiguous memory of about 6 MB.
It is this reference to about 6Mb that I am concerned about. Our systems could be running numerous SQLBackup jobs at the same time putting pressure on the MemToLeave memory so just an increase of a few KB per job would start to give errors by just upgrading from one version to another.
Is there an actual number that can be put into this knowledge base article on a release by release basis or is it always the same?
Thanks
Chris / comments
Thanks Peter.
I have seen this before. Maybe I am confused here but it mentions:-
When SQL Backup performs a backup using the default settings and one file, it requires a block of free contiguous m...