Viewing 15 posts - 1,606 through 1,620 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2015 at 3:37 am
is this a synchronous or asynchronous replica
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2015 at 9:01 am
m.rajesh.uk (10/30/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2015 at 5:49 am
stobe (10/30/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2015 at 8:52 am
even after you remove the database from the group the redo thread on the secondary may well still be applying transactions, this would be required to ensure the database state...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2015 at 8:19 am
Viewing 15 posts - 1,606 through 1,620 (of 9,244 total)