Comments
Sort by recent activity
Thanks for your prompt reply. What should have caused the memory allocation issues? Does it occur because SQL server requires more memory Or may be by accident for some time sql server services were stopped and restatred ( i'm checking that with network admin)?
Becuase for peace of mind i really want to see job successfully run message and it is difficult to test this big back up on other server because of size constraints. If i really need more memory then job will again fail with the same message. Right?
Also can you please let me know some samples on how to use some command to check integrity of this .sqb backup.
Thanks / comments
Thanks for your prompt reply. What should have caused the memory allocation issues? Does it occur because SQL server requires more memory Or may be by accident for some time sql server services we...
Hi Jason,
I looked in to it deeper and the reason the backup file size is not increasing is that there was not enough space left on the disk where we were putting this back up.
All the other backup jobs in sql server which started after this job has failed specifically giving message that there is not enough disk space to perform back up. But this job has not failed. Even right now it's status says executing even when there was no disk space.
I also ran your command master..sqbstatus 1. "processed (bytes)" and "compressed (bytes)" column values remain unchanged.
Now to take care of this issue I emptied more than enough space on the back up disk. But even after that still the job status remains executing but there is no change in the back up file size and also the processed and compressed column values remain unchanged.
What does mean? I have a big 400 GB incomplete backup file but I guess it's not good?Is this job is unsuccessful even though we don't see any error message Or is there any other way to tackle this OR I have to start the back up again from scratch?
Thanks / comments
Hi Jason,
I looked in to it deeper and the reason the backup file size is not increasing is that there was not enough space left on the disk where we were putting this back up.
All the other backup...