Comments
Sort by recent activity
I deinstalled the tools via Control Panel on those servers and that fixed the problem. / comments
I deinstalled the tools via Control Panel on those servers and that fixed the problem.
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered. / comments
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered.
The query returned 0 rows. / comments
The query returned 0 rows.
Did you try the new server components? http://www.red-gate.com/MessageBoard/vi ... php?t=5484
You might also try choosing a lower thread priority on your jobs to see if that helps. It has helped me at times when the server is busy. I find that the default priority RG sets is the same base priority that my SQL server process is running at.
When you say unresponsive, do you mean that you can't do an sp_who2 in Query Analyzer? Is there blocking? / comments
Did you try the new server components?http://www.red-gate.com/MessageBoard/vi ... php?t=5484
You might also try choosing a lower thread priority on your jobs to see if that helps. It has helped me...
Thanks. I'll look into that posibility. / comments
Thanks. I'll look into that posibility.
That was it. The weekend ETL job is truncating the logs under the covers and invalidating the backup chain. I have scheduled around that.
It would be very helpful if the product raised only the base exception and did not raise any higher level generic exceptions to confuse me. The only true exception it raised, but not too clearly, was that there was no current backup.
That was not entirely helpful (or true) as there was a current full backup, it was available, and it was not corrupt. / comments
That was it. The weekend ETL job is truncating the logs under the covers and invalidating the backup chain. I have scheduled around that.
It would be very helpful if the product raised only the b...
There is a very simple way to do it. It's called a where clause. ;-)
1. Create an entry in msdb..syscategories for your backup jobs.
USE msdb
EXEC sp_add_category 'JOB', 'LOCAL', 'red-gate backup job'
2. Select only those jobs, steps, and histories:
select * from msdb..sysjobhistory sjh
join msdb..sysjobs sj on sjh.job_id = sj.job_id
join msdb..syscategories sc on sc.category_id = sj.category_id
where sc.name = 'red-gate backup job'
select * from msdb..sysjobsteps sjs
join msdb..sysjobs sj on sjs.job_id = sj.job_id
join MSDB..syscategories sc on sc.category_id = sj.category_id
where sc.name = 'red-gate backup job'
select * from msdb..sysjobs sj
join msdb..syscategories sc on sc.category_id = sj.category_id
where sc.name = 'red-gate backup job'
It would also be nice of you to select only data newer than the local data. / comments
There is a very simple way to do it. It's called a where clause. ;-)
1. Create an entry in msdb..syscategories for your backup jobs.
USE msdb
EXEC sp_add_category 'JOB', 'LOCAL', 'red-gate backu...
rick.sheeley wrote:
I have been through all the documentation, the help files, and these forums, and nowhere do I see that there are any reporting tools built into SQl Backup, not even something as simple as an output of database, backup type, ran duration , completed, etc."
Have fun:
exec master..sqbdata 'SELECT * FROM backuphistory order by backup_start desc' / comments
rick.sheeley wrote:
I have been through all the documentation, the help files, and these forums, and nowhere do I see that there are any reporting tools built into SQl Backup, not even something...
It doesn't download only backup histories; look at the "jobs" tab on the GUI, it downloads ALL the job histories in MSDB.
I have been nagging them about this behavior as I have servers in NYC, Los Angeles, Pakistan, and India. Their over-selection of data makes the product essentially useless other than for servers in our HQ. The overseas admins don't have a chance of launching the GUI against our servers, and we can't launch it against their servers. It never finishes loading. http://www.red-gate.com/MessageBoard/vi ... php?t=5564
Seems kind of pointless to have those time zone tabs since the product can only be used on a LAN. / comments
It doesn't download only backup histories; look at the "jobs" tab on the GUI, it downloads ALL the job histories in MSDB.
I have been nagging them about this behavior as I have servers in NYC, Los ...