Comments
Sort by recent activity
Wow! I was sure the licensing would be per virtual server instance. This is great news. Let's say I want to run 30 Virtual servers on 1 physical server. How does your license activation mechanism handle this?
If I only buy 1 license and activate it over the internet on Virtual Server 1, will I have to call in for each of the other 29 to have Red Gate adjust the number of times I can use the same serial Number?
Thank You,
Dan / comments
Wow! I was sure the licensing would be per virtual server instance. This is great news. Let's say I want to run 30 Virtual servers on 1 physical server. How does your license activation mechani...
Good to know. I see now the NOTE below that options not only speaks of msdb, but also of the 'internal cache'. I had always just assumed it was for msdb only since I didn't know about the CE file.
Thanks for the answers. I appreciate that Red Gate was open and willing to share that info. Like I said in my first post, this could have easily gone the proprietary route.
Dan / comments
Good to know. I see now the NOTE below that options not only speaks of msdb, but also of the 'internal cache'. I had always just assumed it was for msdb only since I didn't know about the CE file...
Thanks Petey!
Two more questions sprang from your answer. Is there any purging of old data that happens, and where can i find that data.sdf file in a clustered environment. I just checked on one of ours (expected the sdf to have a lot of data), and couldn't find it where you specified. I did find it on a non-clustered install, with no problems, however.
Thank again,
Dan / comments
Thanks Petey!
Two more questions sprang from your answer. Is there any purging of old data that happens, and where can i find that data.sdf file in a clustered environment. I just checked on one ...
Got it!
Thanks / comments
Got it!
Thanks
I just saw the nice little triangle. I didn't realize before that it was a tool tip type icon. I got the message that you can't set custom compareison keys for backups.
Could you explain a little why that is? / comments
I just saw the nice little triangle. I didn't realize before that it was a tool tip type icon. I got the message that you can't set custom compareison keys for backups.
Could you explain a little...
Thanks Brian. After a wasted 4 hours...I found what was blocking it. It's not officially a firewall, but an "antivirus anti mass-emailing worm" piece was set to block anything on port 25 except listed exclusions. Of course this antivirus is controlled at a much higher level on the corporate chain, so I had no idea it was there. Once I added SQBCoreService.exe to the exclude from blocking section...All is well.
D'OH! Just another day in IT
Dan / comments
Thanks Brian. After a wasted 4 hours...I found what was blocking it. It's not officially a firewall, but an "antivirus anti mass-emailing worm" piece was set to block anything on port 25 except l...
That worked, Thanks.
Of course, I understand that properly specifying your columns on an insert operation will avoid any issues that may arrise from the columns being in a different order, but it still seems like it should be a more basic/default option...to me anyway.
Anyway, thanks for the answer medwards! / comments
That worked, Thanks.
Of course, I understand that properly specifying your columns on an insert operation will avoid any issues that may arrise from the columns being in a different order, but it s...
Thank you for your responses. As far as permissions go, both the SQL Backup agent and the user I used to test xp_msver have sys admin rights to the sql server in question.
My plan for now is to do the install and run with the extended stored procedure. At a future time, I will try to rerun the SP4 Install. I have a feeling my problem is in there somewhere, as I didn't do the install. I have no way of knowing if it completely successfully or not.
Thanks again,
Dan / comments
Thank you for your responses. As far as permissions go, both the SQL Backup agent and the user I used to test xp_msver have sys admin rights to the sql server in question.
My plan for now is to do...
I agree. It's interesting that Microsoft obviously saw the problem, because they worked around it when you have SSMS create a script.
Oh well. Thankfully, I just purchased the Developer Bundle, which includes SQL Refactor, so I'm good to go. [image]
Unfortunately, I think you'll have others seeing this as a problem, even though it may not, technically, be your fault.
Good luck.
Thanks,
Dan / comments
I agree. It's interesting that Microsoft obviously saw the problem, because they worked around it when you have SSMS create a script.
Oh well. Thankfully, I just purchased the Developer Bundle, w...
SSMS 2005 9.00.4035.00 / comments
SSMS 2005 9.00.4035.00