Viewing 15 posts - 1,426 through 1,440 (of 9,244 total)
PJ_SQL (2/2/2016)
I have 4 node cluster. I would need to patch all nodes right?I can't just update one with recent service pack and leave other 3 as is
Thanks
Depends what instances...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 1:49 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 1:45 am
a cert is an asymmetric key, what is it you are expecting to see
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 1:40 am
SQL!$@w$0ME (2/2/2016)
Thanks a lot Perry! Appreciate your help!!
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2016 at 3:38 pm
Steve Jones - SSC Editor (2/2/2016)
There are also lots of scripts on this site in the script library[/url].
Yeah but mine is super awesome ??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2016 at 3:37 pm
a one node cluster will not support an availability group.
An availability group requires at least 2 replicas which must reside on separate nodes, therefore a 2 node cluster minimum is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2016 at 10:51 am
Here's my script, feel free to modify it as required, not that it should need it
SET NOCOUNT ON
DECLARE @sql NVARCHAR(MAX)
DECLARE @majver INT
DECLARE @minver INT
DECLARE @build VARCHAR(16)
SET @sql = ''
SET...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2016 at 10:47 am
as I said here, remove the current log shipping secondary database and add a new log shipping secondary. The primary stays in place
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 11:28 am
parmodsingh (3/20/2012)
Can anyone help me to get this problem resolution. I want to rename one of my logshipping secondary database without removing existing logshipping.
You don't remove Log shipping completely, the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 9:59 am
Steve Jones - SSC Editor (2/1/2016)
SQL 2005 direct upgrade is not supported. You can attach SQL 2005 data files to 2016 according to the docs.
Yes this is detailed in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 9:48 am
happycat59 (1/3/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 9:46 am
Briceston (2/1/2016)
So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder. My next...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 9:30 am
curious_sqldba (2/1/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 9:00 am
dajonx (2/1/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 8:56 am
Peter McLarty (1/31/2016)
The company I am working generally denies Server Admin rights to the DBA. I have to set up log shipping and I can see that with 2008 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2016 at 4:09 am
Viewing 15 posts - 1,426 through 1,440 (of 9,244 total)