Perry Whittle

Forum Replies Created

Viewing 15 posts - 541 through 555 (of 9,244 total)

RE: Create empty AlwaysOn Availability Group

icester - Monday, September 11, 2017 9:47 AM
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-availability-group-transact-sql
The FOR keywork is required, only the DATABASE clause is optional. The link...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 13, 2017 at 7:17 am

#1959237
RE: Use strong encryption for data

jayoub - Friday, September 8, 2017 8:17 AM
Thanks for the reply
Yes TLS 1.0 is disabled and TLS 1.2 is enabled -...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 8, 2017 at 8:23 am

#1958726
RE: Failover Cluster reliability in a shop with limited experience in clustering

chuck.forbes - Thursday, September 7, 2017 8:53 AM
I'll check out your stairway, and then get back to this post once we have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 8, 2017 at 4:13 am

#1958698
RE: Use strong encryption for data

sounds like it could be a TLS issue
Have you disabled TLS1.0 and only using TLS1.2 by any chance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 8, 2017 at 4:08 am

#1958696
RE: Error moving log.ldf

Riic - Thursday, September 7, 2017 8:04 PM
I may not have access right to change location to "Local Machine", will try again.
??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 8, 2017 at 4:06 am

#1958695
RE: Best way to move the log file to a different drive

William Rayer - Thursday, September 7, 2017 7:38 AM
Under this link https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases (see Planned relocation Procedure), Microsoft say:
1. Take the DB offline
2....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 7:51 am

#1958566
RE: Availability group listener permissions

as1981 - Thursday, September 7, 2017 7:00 AM
Hello,
Thanks for your help.
It might not have all the admin permissions but it should have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 7:47 am

#1958565
RE: Asymetric Keys - Where are they? - DISCUSSION

have you read this
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-asymmetric-key-transact-sql
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 6:50 am

#1958552
RE: Availability group listener permissions

as1981 - Thursday, September 7, 2017 6:25 AM
All,
I'm trying to add the first listener to a new AG using SSMS.
I'm using the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 6:46 am

#1958550
RE: Error moving log.ldf

Riic - Wednesday, September 6, 2017 8:43 PM
Thank you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 5:09 am

#1958534
RE: Failover Cluster reliability in a shop with limited experience in clustering

chuck.forbes - Wednesday, September 6, 2017 9:42 AM
For us, downtime in the cluster is related to a loss of mapping for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 7, 2017 at 3:39 am

#1958521
RE: Error moving log.ldf

Riic - Wednesday, September 6, 2017 3:33 AM
Thanks you GURUs for the prompt response!
To give permission, i right click folder-->Properties-->Security tab-->give Full...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 6, 2017 at 5:16 am

#1958306
RE: Migrate from SQL SERVER 2005 to 2012

sram24_mca - Tuesday, September 5, 2017 11:41 PM
Hello Everyone,
I am facing Issue when creating the new database in SQLSERVER 2012 with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 6, 2017 at 2:50 am

#1958292
RE: COPY_ONLY backup and running transactions?

jCoke - Tuesday, September 5, 2017 6:01 AM
how does it work with a COPY_ONLY backup ? since its not chaning the LSNs?
Note:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 6, 2017 at 2:47 am

#1958291
RE: Error moving log.ldf

Riic - Wednesday, September 6, 2017 12:19 AM
Also tried give full permission...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

September 6, 2017 at 2:39 am

#1958289

Viewing 15 posts - 541 through 555 (of 9,244 total)