Viewing 15 posts - 16 through 30 (of 37 total)
I was afraid of that. I was hoping there was an option somewhere I haven't found where you could just point the standby server to a directory full of...
February 9, 2011 at 8:03 am
S.K. is exactly right.
One thing to watch out for, for some reason, every time I've done the upgrade, the upgraded node becomes deselected in the "Possible Owners" Advanced Policy for...
February 8, 2011 at 8:13 am
A domain account, but I figured out the issue. Apparently you have to set the permissions manually, as when clustered, the account does not show in the gui?
icacls directoryName...
May 3, 2010 at 2:20 pm
Same issue here. Any luck?
May 1, 2010 at 9:21 am
I didn't run into any resource db issues in my experiments, but luckily, my sql binaries go to the default c:\... location on all installs.
What a recipe for...
April 7, 2010 at 12:33 pm
Interesting discussion, thanks guys!
To answer some of the speculation, yes, this is absolutely just a "What if..." type of practice thing for me. I'm trying to go through some...
April 7, 2010 at 8:41 am
Haha, okay, noted 🙂 Thanks for the advice!
April 5, 2010 at 9:13 am
Thanks David, that did the trick. I don't know why my original method didn't work, I was under the assumption /m /c /T3608 should prevent non-master DBs from starting...
April 2, 2010 at 1:14 pm
Do you actually see the job being fired off on the server its disabled on?
I ran into a sort of similar issue where a SSIS package was being run, despite...
March 30, 2010 at 9:55 am
EDIT: Oops, didn't see the 2nd page, first pass.
December 8, 2009 at 3:45 pm
We were capturing that already. It would have been helpful to mention it in my first post, eh? 🙂
The only non-negligible differences between the two runs comes in...
November 25, 2009 at 1:45 pm
Okay, confused even more now. You're saying the domain account that runs the SQL Agent service has to be domain admin? Or the share has to have the...
November 20, 2009 at 11:39 am
Makes sense, but my Agent account has admin already, and the errors I'm getting are OS access denied issues. It lacks the permissions to open the file on the...
November 20, 2009 at 9:55 am
That sounds reasonable, and makes sense, but it's not what I'm seeing, unless I'm missing something.
When you say owner, you mean the SQL Server Login owner of a job? ...
November 20, 2009 at 9:31 am
Sorry, I was a little light on details.
The SQL job calls a stored procedure. The stored procedure accesses the files on a file share via UNC. The stored...
October 28, 2009 at 7:22 am
Viewing 15 posts - 16 through 30 (of 37 total)