Perry Whittle

Forum Replies Created

Viewing 15 posts - 271 through 285 (of 9,253 total)

RE: AG Database stuck in restoring when server removed from AG

david.pilcher - Tuesday, October 2, 2018 9:08 AM
Hi
We have an AG that was running on 2016 and deleted a server in the...

October 4, 2018 at 3:26 am

#2008006
RE: SPN for sql 2016 cluster

Alejandro Santana - Tuesday, October 2, 2018 12:32 PM
No, the 2 nodes don't need to have the same Service account.
The...

October 4, 2018 at 3:23 am

#2008005
RE: Difference between AG && FCI

joujousagem2006 1602 - Sunday, September 23, 2018 7:38 AM
Hi,
what is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances
thanks
please see...

October 1, 2018 at 5:50 am

#2007479
RE: Always on with an SQL Cluster and 2 nodes

Joe Zonum - Friday, September 28, 2018 12:19 PM
Hello all,
I have searched everywhere and can't seem to find an example of setting...

October 1, 2018 at 4:29 am

#2007471
RE: Script to View Server Role Permissions

Phil Parkin - Thursday, September 27, 2018 6:17 AM
I have a script which creates a server role called dbareadonly. Here is part...

October 1, 2018 at 4:27 am

#2007470
RE: Failover - AG issue

sizal0234 - Wednesday, September 26, 2018 11:58 AM
Hi All,
Issue: We have 2 instances say A01 AND A02.
The client has network issue...

October 1, 2018 at 4:24 am

#2007469
RE: AlwaysOn Listener registering 2 DNS records

SQLAddict01 - Sunday, August 19, 2018 10:56 AM
We have a requirement that we are not allowed to make any changes in the...

September 6, 2018 at 5:56 am

#2004686
RE: Always on Install

caz100 - Thursday, August 23, 2018 1:05 AM
Hi
I am following these notes for always on install and have some basic queries:
http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/
For...

September 6, 2018 at 5:51 am

#2004683
RE: Setup 2 node windows cluster

caz100 - Tuesday, August 28, 2018 3:26 AM
HiWe have a requirement to setup a windows 2 node failover cluster with sqlserver installed outside...

September 6, 2018 at 5:49 am

#2004682
RE: Mirroring Failover

Admingod - Thursday, August 30, 2018 10:56 AM
I have question,
Server A is mirrored to Server B when the failover is done server...

September 6, 2018 at 5:48 am

#2004681
RE: SQLServr.exe cannot find ERRORLOG error(17058)

elea.grig - Saturday, August 25, 2018 4:05 AM
While running SQLServr.exe -sMSSQLSERVER command I get the error pictured above. How...

September 6, 2018 at 5:43 am

#2004678
RE: DAC connection vs single-user mode

elea.grig - Saturday, August 25, 2018 3:19 AM
Are sqlcmd -A and SQLServr.exe -f doing the same job? What is the difference between...

September 6, 2018 at 5:41 am

#2004677
RE: SQL Migration

Sue_H - Tuesday, September 4, 2018 2:11 PM
Andrew.weckermann - Friday, August 31, 2018 3:08 AM

September 6, 2018 at 5:36 am

#2004676
RE: Why QUOTENAME is important

Good article, important to remember a simple check of permissions catches sql injection. Why give an account create table in the first place

August 15, 2018 at 12:11 am

#2001778
RE: SQL 2017 FCI with File Share Witness - permissions?

robnsilver - Tuesday, July 3, 2018 1:01 PM
I think you only need to grant permissions on the file share to the cluster...

July 9, 2018 at 6:54 am

#1996774

Viewing 15 posts - 271 through 285 (of 9,253 total)