Viewing 15 posts - 1,606 through 1,620 (of 9,253 total)
udara0306 (10/31/2015)
Hi,My always on cluster 2 replica with sync mode and DR one with Async mode.
regards
ud
If you have 2 replicas configured for synch mode and auto failover the transition will...
November 2, 2015 at 3:45 am
ram1447 (10/31/2015)
We use SQL server always on feather on my database and we distribute statement on main database server and mirror database server for raise performance.
My police for split...
November 2, 2015 at 3:37 am
is this a synchronous or asynchronous replica
October 30, 2015 at 9:01 am
m.rajesh.uk (10/30/2015)
October 30, 2015 at 7:12 am
stobe (10/30/2015)
I didn't give them CREATE ENDPOINT, I gave them CONNECT ON ENDPOINT
I didn't say you did give them create, I'm pointing out they may need this on a...
October 30, 2015 at 5:49 am
stobe (10/30/2015)
October 30, 2015 at 5:39 am
muzikfreakster (10/29/2015)
What are the potential risks of keeping data , log , tempdb backups etc in the same drive although in different folders ?
It all depends on how the volume(s)...
October 30, 2015 at 5:32 am
Mahesh Bote (10/30/2015)
Does rather than Dropping the Index, Disabling it would be the best approach? I have one stored procedure where Indexes are being dropped and recreated. So I...
October 30, 2015 at 5:29 am
ensure your logs are sized appropriately and make sure they're segregated to fast disks would be a start
October 30, 2015 at 5:16 am
pod69 (10/30/2015)
i had to move some sqlserver from one to another host.
So on the new host I installed sqlserver with the original Configuration.ini from the old host.
Then I copied the...
October 30, 2015 at 4:48 am
MSA's also fully support the use of SPNs so they're perfect for use in instances that are replicas in an availability group
October 30, 2015 at 4:45 am
i1888 (10/29/2015)
It is network account(domain account), it has permission to run backup etc.
This does not guarantee that access permissions are set so check them on the remote server.
xp_subdir will...
October 30, 2015 at 4:42 am
stobe (2015-10-30 6:26 PM)
I have now granted connect on the endpoint to the Windows NT group
Why???
The account that requires connect on the endpoint is usually the account that the sql...
October 30, 2015 at 4:32 am
udara0306 (10/29/2015)
I need a advice.
1. Once fail over to secondary replica, what will happen to connected session in primary node? can the session fail over to secondary seamlessly or...
October 30, 2015 at 4:25 am
stobe (10/29/2015)
I have a permissions issue that I am hoping you can help me with. I have a Windows NT group that is used to delegate certain database responsibilities...
October 29, 2015 at 8:52 am
Viewing 15 posts - 1,606 through 1,620 (of 9,253 total)