Activity overview
Latest activity by steverowlands
Apologies, yes they have all gone from the list, looks like the last email alert we got was at 10:21 this morning which was about an hour before I checked the database.
Thanks for the assistance with this.
Steve / comments
Apologies, yes they have all gone from the list, looks like the last email alert we got was at 10:21 this morning which was about an hour before I checked the database.
Thanks for the assistance wi...
Thanks for the reply.
I ran EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist WHERE status = ''P'' ' and it returned no rows.
So I ran:
EXEC master..sqbdata 'SELECT status, count(*) FROM backupfiles_copylist group by status '
and got:
Status
E 1346
S 7996
Is it safe to set all these to status 'C'? / comments
Thanks for the reply.
I ran EXEC master..sqbdata 'SELECT * FROM backupfiles_copylist WHERE status = ''P'' ' and it returned no rows.
So I ran:
EXEC master..sqbdata 'SELECT status, count(*) FROM bac...
How do I cancel pending jobs in the Log Copy Queue?
Our off-line storage device has failed so the "copy backup to network" has been failing.
I have amended the jobs so they will no longer attempt to do this but I also need to clear down the queue of...