Comments
Sort by recent activity
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...
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...
4.5.0.704 / comments
4.5.0.704
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...
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...
Ok got a little more info:
I copied a bunch of logs to a new directory, ran the script over those, it was fine.
Copied all the logs to this directory and it failed.
Altered the mask to _20060930_09*.sqb and its fine (as was 07* and 08*). Altering it to _1* then leads to failure.
Something is not right here, would appreciate some feedback - it was working fine before!!?! [image] / comments
Ok got a little more info:
I copied a bunch of logs to a new directory, ran the script over those, it was fine.
Copied all the logs to this directory and it failed.
Altered the mask to _20060930_09...
Ok thanks.
I have stuck in a conditional xcopy as the next step. This seems to overcome the issue.
Anyone else bothered by this feel free to pm me. / comments
Ok thanks.
I have stuck in a conditional xcopy as the next step. This seems to overcome the issue.
Anyone else bothered by this feel free to pm me.