Activity overview
Latest activity by reinisb
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...
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 ...
Mediaset families missing after conversion from SQB
Hi,
I have an SQB backup that I converted back to a .BAK so I could restore through the SQL Server native GUI.
During the conversion the SQB was extracted to 23 seperate BAK files. If I understand ...
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
Restore Log takes many hours to fail
Hi,
We have a daily log restore to a secondary database. For one reason or another, we have problems getting all the user connections to be automatically disconnected before the restore starts and...
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...
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...