Comments
Sort by recent activity
It could be because of the size of msdb. I hadn't realized that it was as big as it was because it has DTA data in it.
Thanks
Chris / comments
It could be because of the size of msdb. I hadn't realized that it was as big as it was because it has DTA data in it.
Thanks
Chris
Look at the topic RESOLVED: Upgrade fails to verify version to see how to clear up the upgrade failure.
When you installed SQLBackup did you use SQL authentication and use the sa account to run SQLBackup?
Chris / comments
Look at the topic RESOLVED: Upgrade fails to verify version to see how to clear up the upgrade failure.
When you installed SQLBackup did you use SQL authentication and use the sa account to run SQL...
Just what I needed to. It worked like a charm. Adding it to the GUI will be a good thing.
Thanks Priya
Chris / comments
Just what I needed to. It worked like a charm. Adding it to the GUI will be a good thing.
Thanks Priya
Chris
If you mean that your job is still running by seeing it in the In Progress tab and you have Verify on then you have a known problem. Red gate are hoping to have this fixed in 5.5.
Chris / comments
If you mean that your job is still running by seeing it in the In Progress tab and you have Verify on then you have a known problem. Red gate are hoping to have this fixed in 5.5.
Chris
Aaron,
You at least are not getting the 1010 error where SQLBackup is using the MemToLeave memory and needs this to be contiguous. SQLBackup is pretty resource hungry and if you use the GUI to run the jobs rather than schedule them you can exhaust the resources.
I have had this problem on occasion and just had to make sure I was not running too many SQLBackups jobs at the same time and I think that the system drive was low on space. I believe that it is this last point that is causing your problem.
Chris / comments
Aaron,
You at least are not getting the 1010 error where SQLBackup is using the MemToLeave memory and needs this to be contiguous. SQLBackup is pretty resource hungry and if you use the GUI to run ...
Jason,
if you have a licence for both servers it is not difficult. You can use the GUI to look at the .sqb backup and go thru the screens specifying if this is a new database and wehere you want to put the DB files and what you want them called. If you only have one licence then there is a utility to take a Red gate backup and convert it to the native SQL backup.
HTH
Chris / comments
Jason,
if you have a licence for both servers it is not difficult. You can use the GUI to look at the .sqb backup and go thru the screens specifying if this is a new database and wehere you want to...
Thanks for the reply.
That's not the best news to hear.
Chris / comments
Thanks for the reply.
That's not the best news to hear.
Chris
I am wondering why there has been no response to this question?
Chris / comments
I am wondering why there has been no response to this question?
Chris
I will raise a post asking about SB-3421 and let you update it.
Chris / comments
I will raise a post asking about SB-3421 and let you update it.
Chris
I will try it out on one of our larger backups.
Chris / comments
I will try it out on one of our larger backups.
Chris