Viewing 15 posts - 2,386 through 2,400 (of 9,244 total)
Reg_Mayfield (2/11/2015)
Since one of the nodes is our DR node it should not have a votethat is according to all the articles I have read.
Where have you read this,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 8:27 am
your questions not clear, typically you may offload backup operations to secondary databases.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 7:25 am
moving a later version of the resource database will also stop a patch of the same version installing if its ever needed. I faced this very same issue sometime ago...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 6:32 am
ALZDBA (2/11/2015)
and a great series it is ! :Wow:
Thank you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 6:29 am
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !
My stairway series details this, has been linked and is available on this site
ALZDBA (2/11/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:33 am
Igor Micev (2/11/2015)
Thanks Perry, it works. I shouldn't have restored the DMK but create it as you proposed.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:07 am
if the user exists as a member of the sysadmin role you do not need to map them into databases, they can do what the hell they like anyway!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:05 am
Reg_Mayfield (2/10/2015)
everything I read would indicate we need a third node (odd number) (e.g. a fileshare Witness)
Yes, the vote count should have an odd number to provide a majority in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:03 am
sqldriver (2/10/2015)
No big deal. I get the proportional fill algorithm.
if one file is 11TB and you add a new file to the same filegroup. Proportional fill will just increase writes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 3:55 am
you could possibly script this but do you want to be blindly adding new databases to availability groups?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 3:51 am
johnnyrmtl (2/10/2015)
Perry Whittle (2/10/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 10:45 am
the whole point with AlwaysOn availability groups is you don't need shared storage. Put a 3rd node in the cluster on the remote site and put a standalone instance of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 10:39 am
johnnyrmtl (2/10/2015)
Perry Whittle (1/21/2015)
johnnyrmtl (1/21/2015)
I need to propose a 2 server clustering / failover solution with SQL 2012 and it seems that the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 10:02 am
APA0876 (2/10/2015)
Always On - SQL Server 2012 Enterprise edition -1- Does Requires to pay for an extra license of SQL Server Enterprise Edition?
Licensing is a grey area, download the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 10:01 am
Igor Micev (2/10/2015)
I have an issue to restore an encrypted backup via GUI.
I can restore an encrypted backup on another instance using t-sql command, but cannot do the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 9:24 am
Viewing 15 posts - 2,386 through 2,400 (of 9,244 total)