Perry Whittle

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 9,244 total)

RE: Using TLS 1.2

jayoub - Wednesday, February 15, 2017 7:36 AM
Thank you very much for the reply
We are using Windows Server 2008R2 for both the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 16, 2017 at 8:42 am

#1928868
RE: Upgrade from 2014 Enterprise to 2016 Standard

postfix - Thursday, February 16, 2017 5:25 AM
As I can see this upgrade path is supported.

https://msdn.microsoft.com/en-us/library/ms143393.aspx
During in-place upgrade I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 16, 2017 at 7:22 am

#1928840
RE: connection handshake error while configuring availability group.

please provide more detail around your setup such as user accounts running the sql services and your exact sql server version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 16, 2017 at 4:40 am

#1928801
RE: Using TLS 1.2

jayoub - Tuesday, December 20, 2016 1:29 PM
We have SQL Server 2008R2 SP3 and I did the followingA: Enabled TLS 1.2 B:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 15, 2017 at 7:10 am

#1928615
RE: SQL Server Export Wizard Problem with constraints

Or drop the constraint first and recreate it afterwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 15, 2017 at 6:57 am

#1928611
RE: SQL Server Export Wizard Problem with constraints

I could be wrong but I'm guessing the question is
how do I fix it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 15, 2017 at 6:20 am

#1928595
RE: SQL Server Export Wizard Problem with constraints

what is it you're after?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 15, 2017 at 5:19 am

#1928584
RE: Performance improves after reboot

Anytime sql server performs an operation on data it must first be read from the disk subsystem into physical memory.
Disk subsystem access times are typically 10-15 milliseconds.
Random access memory operates...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 14, 2017 at 5:37 pm

#1928527
RE: AlwaysON - Listener on different Subnet than both nodes?

CaptnHk - Tuesday, February 14, 2017 8:10 AM
I have a need to alter the IP/subnet of the Listener to be on a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 14, 2017 at 10:51 am

#1928433
RE: Permission to grant access to database

Robin35 - Tuesday, February 14, 2017 9:45 AM
Thom A - Tuesday, February 14, 2017 8:55 AM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 14, 2017 at 10:47 am

#1928430
RE: Flipping between SIMPLE and FULL recovery mode

Ken McKelvey - Tuesday, February 14, 2017 7:25 AM
True but even if the log is being backed up every 5 minutes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 14, 2017 at 10:45 am

#1928428
RE: Unexplained jump in Backup File

Please post the output of this query, replace the DRIVE, PATH and BACKUPFILENAME placeholders as required
restore
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

February 13, 2017 at 9:43 am

#1928144