Comments
Sort by recent activity
Thanks Petey for the response.
I tried it again and it worked. It's possible I was being a doofus and trying to restore files and filegroups instead of database (it was friday afternoon after all :roll: ), but I'm not sure.
I will go to Profiler quicker next time!
Thanks.
Reinis / comments
Thanks Petey for the response.
I tried it again and it worked. It's possible I was being a doofus and trying to restore files and filegroups instead of database (it was friday afternoon after all ...
The value is 24576 which would be 6.8 hours (I assume that is in seconds) so it seems to make sense. I have no idea why that would be set to such a high value. I switched it to 30 so we'll see what happens with that.
Thanks,
Reinis / comments
The value is 24576 which would be 6.8 hours (I assume that is in seconds) so it seems to make sense. I have no idea why that would be set to such a high value. I switched it to 30 so we'll see wha...
Standy/Read-only because it's the log shipping target.
Reinis / comments
Standy/Read-only because it's the log shipping target.
Reinis
Strange. I looked at the timeline today and it seems to be correct for the current backups now. The diff backup is no longer shown as running continuously. [image]
Unfortunately, all the backup history is missing for about a two week period (even from the Activity History tab) - it seems some kind of reset happened which cleaned up the problem, but also wiped out the history. At least the history still exists in the SQL Server Agent log. :roll:
I'll be interested to see if anyone else posts a similar issue but in the meantime, thanks to the viewers of this thread,
Reinis / comments
Strange. I looked at the timeline today and it seems to be correct for the current backups now. The diff backup is no longer shown as running continuously.
Unfortunately, all the backup history ...
Thanks for the prompt response. I will try that when I get a chance.
I have to say that does seem a slightly heavy-handed approach. That basically disables part of the selling points of SQL Backup. To check if everything succeeded, I have to click on each server seperately and look for any failures - which requires some scrolling for the servers I have 15min transaction log backups on (unless there is another way to look at all the backup history at once that I don't know of). Also, the first page of the timeline actually displays quickly (sometimes) but the activity doesn't load. Is the whole timeline attempting to load or something? The other servers only load a day or two initially as well but their activity history shows up quickly.
Thanks,
Reinis / comments
Thanks for the prompt response. I will try that when I get a chance.
I have to say that does seem a slightly heavy-handed approach. That basically disables part of the selling points of SQL Backu...
In case anybody else comes across this thread, the solution that actually worked for me was to select the Delete Old Backup History in the Server Options dialog (right-click the server name to access). Once I selected that and set a number of days, it took a lot less time for Redgate to show the timeline and activity history correctly. / comments
In case anybody else comes across this thread, the solution that actually worked for me was to select the Delete Old Backup History in the Server Options dialog (right-click the server name to acce...
This is an old thread, but I have the same kind of situation with one of our servers that has 86 databases on it. If I close and reopen SQL Backup UI a couple of times it eventually displays the activity history, but it takes a while. It seems like maybe it should display the top 100 records quickly, then try to load the rest in the background or something.
Any news on this?
Reinis / comments
This is an old thread, but I have the same kind of situation with one of our servers that has 86 databases on it. If I close and reopen SQL Backup UI a couple of times it eventually displays the a...