Activity overview
Latest activity by RichardB
Ah interesting. This also seems to be blocking the differential backup for those dbs too. [image] / comments
Ah interesting. This also seems to be blocking the differential backup for those dbs too.
at this point sqbstatus sits with both the inert processes with 0 in the processed and compressed, while the one that is still functional pops in and out with large numbers or no record (presumably depending on whether its running at the time!) / comments
at this point sqbstatus sits with both the inert processes with 0 in the processed and compressed, while the one that is still functional pops in and out with large numbers or no record (presumably...
While we are here... I also am now getting a problem with teh log backups.
I see that the cluster got bounced while one log was being backed up, then bounced back while a different databases log was being backed up.
A third databases logs are fine, but those 2 just sit doing nothing, and don't back up.
A standard mssql log backup works fine tho. I have restarted the sqlbackup service, to no avail. / comments
While we are here... I also am now getting a problem with teh log backups.
I see that the cluster got bounced while one log was being backed up, then bounced back while a different databases log wa...
4.5.0.704 / comments
4.5.0.704
Also I get quite a lot of
Error 920: Failed to update backup history table (BACKUPMEDIAFAMILY).
SQL error 1205: Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
When I have simultaneous backups or restores happening. / comments
Also I get quite a lot of
Error 920: Failed to update backup history table (BACKUPMEDIAFAMILY).
SQL error 1205: Transaction (Process ID 64) was deadlocked on lock resources with another process an...
Bad file leading to SQLBackup invisible hang
Slightly odd scenario here, resulting in:
18210 :
BackupMedium::ReportIoError: read failure on backup device 'SQLBACKUP_A7B98D34-4268-4F1C-8BDA-DDD07071EEE3'. Operating system error 995(error not...
Great, thanks pete. / comments
Great, thanks pete.
Ah, excellent, yes they are. This presumably gives us confidence it is still working...
What do they represent? Am I right in assuming that Processed(Bytes) is the amount that has restored (/1024/1024/1024 to get gb? - on 60 ish and 20 after 5 hours)
The database being restored has 2 filegroups + logs - are they treated as a whole in these numbers?
Cheers for the response,
Rich / comments
Ah, excellent, yes they are. This presumably gives us confidence it is still working...
What do they represent? Am I right in assuming that Processed(Bytes) is the amount that has restored (/1024...
Unexpectedly long duration on Restore, no feedback.
Hi
Current issue: Restoring a 200GB database over vpn. Seems to be taking much longer than expected, and I can't see any feedback on progress.
DB is marked as loading, query is still 'running', bu...
Thanks. I was hoping you'd say 'Yes! Here is a link to our free snapshot browser, so you can distribute snapshots in a funky browsable manner'.
Ah well, back to enterprise manager for that job then [image]
Rich / comments
Thanks. I was hoping you'd say 'Yes! Here is a link to our free snapshot browser, so you can distribute snapshots in a funky browsable manner'.
Ah well, back to enterprise manager for that job the...