Activity overview
Latest activity by dsharpe2
Error Writing To Backup File
We received the following error last night and were wondering if you could advise us as to the problem:
We are backing up multiple databases within one step. The first 35 backups work with no error...
It could be the same except that with the other proble it did come back later. In this case it does not ever seem to come back or it is taking so long as to make it about the same thing.
I created another backup that was single threaded and added the verify option to it. This was started an hour or so after the original SQBHEADERONLY had started. The single threaded job completed the backup and verify and the SQBHEADERONLY was still running.
I finally killed the SQBHEADERONLY a few hours later.
At this point we have all our backups running single threaded as the risk of data loss is a little too high. [image] / comments
It could be the same except that with the other proble it did come back later. In this case it does not ever seem to come back or it is taking so long as to make it about the same thing.
I created ...
Multiple Thread Backup Issue – SQBHEADERONLY Never Completes
When I make a multiple threaded backup of a large database 240 GB + and run RESTORE SQBHEADERONLY it never completes.
Example syntax:
master..sqlbackup N'-SQL "RESTORE SQBHEADERONLY FROM DISK = ''I...