Viewing 15 posts - 46 through 60 (of 252 total)
There is a known issue with the newest cumulative updates that can cause this. Are you on that patch version?
January 28, 2015 at 10:53 am
Thanks Perry. The SQL Server FCI installer was pointed to a cluster group volume but due to an issue with Windows Server 2012 R2 and Symantec Storage Foundation for Windows,...
December 10, 2014 at 10:47 am
It seems as a work around I can create a role with View Folder permission only and assign that in home folder to domain users.
September 29, 2014 at 5:54 pm
Hi Gail and Jack,
c2 auditing is not enabled. Common Criteria compliance is enabled.
I've checked all of the Agent jobs. None of them are set to execute at start up.
This...
July 8, 2014 at 11:56 am
Hi thanks for the responses. I generated a new certificate request file and sent it to our certificate authority. The certificate that was returned did generate a private...
April 17, 2014 at 10:30 am
I'm thinking of partially contained database so in the case the instance doesn't need to come across, just the database with the contained users.
Is it true that I would want...
April 3, 2014 at 6:15 pm
I had hoped to have a failover order for AGs using preferred nodes similar to how FCIs work.
S1 is primary. If S1 becomes unavailable, automatically failover to S2 which is...
March 12, 2014 at 12:38 pm
We hoped to have a failover priority order. Three synchronous replicas. One secondary locally and one in the other datacenter so that if the primary replica server fails, it would...
March 11, 2014 at 6:18 pm
Thanks for the article on how it works SQLBuddy. It looks like it just isn't possible to have more than 2 replicas set in auto failover mode. I...
March 10, 2014 at 4:59 pm
Are you using an AG listener to connect to the AG databases?
If so, the most reliable method is to use SQL Native Client 11 or JBDC v4.
Specify MultiSubnetFailover=True in the...
March 10, 2014 at 11:59 am
I picked 250GB for data and 100GB for logs and 100GB for tempdb so that I'd have room to grow. Don't recall seeing tempdb grow that big unless some application...
January 30, 2014 at 10:32 am
I was also confused because Brent Ozar's checklist has an example of putting tempdb data on one drive and tempdb log on another so thought in my case, I'd move...
January 30, 2014 at 10:28 am
Oh and as for sizes, server team gives us 50GB for C, and I usually request 250GB for data on D and 100GB for logs on L and 100GB for...
January 30, 2014 at 10:23 am
We back up to data domain appliances that replicate the backups to another data center for DR emergencies so I was not factoring in backup space on each server.
January 30, 2014 at 10:18 am
Viewing 15 posts - 46 through 60 (of 252 total)