Viewing 15 posts - 2,386 through 2,400 (of 9,241 total)
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
gary1 (2/9/2015)
So, do we need to take full backups and send to DR location and reconfigure log shipping natively?
No, just remove the Litespeed Log shipping plan apply any remaining logs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 4:57 am
johnnyrmtl (2/9/2015)
SQL login 🙂
My script above will work, don't forget to change the username and any roles you wish to grant
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2015 at 4:54 am
johnnyrmtl (2/9/2015)
Just to clarify... I added a new server login on a new instance and I would only need to add this login to over 700...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2015 at 10:09 am
Viewing 15 posts - 2,386 through 2,400 (of 9,241 total)