IanG
  • Member for 6 years, 6 months
  • Last seen more than a month ago
linked servers between availability group to a server
2 votes

You will need to create an identical linked server on each of your 3 Availability Group nodes (server1, server2, server3). Linked servers (like logins, alerts, and jobs) are instance level objects so ...

View answer
How to configure SSIS in SQL Server AlwaysOn
2 votes

The short answer is there is no way to configure SSIS for Always-On with SQL Server 2014 and below. SSIS, just like SSRS, SSAS, jobs, logins, alerts and other minor things that operate at the ...

View answer
SQL Server Partially Contained Databases and Linked Servers
2 votes

There does not seem to be an issue for me querying a Linked Server from a partially contained database when logged in as a contained user. I would always recommend using a synonym. I did this on a ...

View answer
How to enable/disable SQL agent jobs during fail over (AlwaysOn)
Accepted answer
2 votes

There are several ways to automate this and you are heading down the right path...you can rely on your DBA to manually disable and enable (not very nice ;), you can keep track of job state in a table ...

View answer
SQL Server AG - Is there any case for un-clustering prior to certain operations?
Accepted answer
2 votes

Yes they are correct it will increase the execution time. As the comments state though there is no measurable way to determine this unless you have a matched test/stage environment and try it both ...

View answer
SQL Query is getting progressively slower
2 votes

Try SET ARITHABORT ON in your client application... Why would SET ARITHABORT ON dramatically speed up a query? I have almost always seen this to be differences between the ADO(usually OFF) and SSMS(...

View answer
Is it safe or possible to change SQL Server AutoGrowth when in a SQL Server AlwaysOn Cluster
1 votes

You have to have AutoGrow enabled and do it on the primary replica. You can also do it in t-sql using the ALTER DATABASE command.

View answer
I do not see SQL Server instance name under roles section of Fail over cluster manager screen! How to setup?
Accepted answer
1 votes

You have to actually create the Availability Groups first, then it will show up in FCM. You have basically finished the prerequisite steps to allow an Availability Group to be created...so let's go ...

View answer
SQL Agent Proxy - writing to logs is only allowed to jobs that are owned by sysadmin
1 votes

I would work on educating your security team about jobs...they are server/instance level objects, not database level objects, so db_owner seems severely limited. Ola recommends sysadmin for the job ...

View answer
Should I create a child table without primary key?
1 votes

If the records needs to be unique, then it is up to you to either pick a composite key (multiple columns) to make them unique, or use a primary key (unique by definition). I don't think there is ...

View answer
SQL Server AlwaysOn from multiple origins to a single secondary replica server
1 votes

No it is not possible to set up three availability groups of different SQL Versions (I think that is your real question). It is possible to set up an availability group solution to meet your needs, ...

View answer
AlwaysOn - Problem with adding secondary replicas
0 votes

I use netsh to open as many (or few) standard SQL Ports in the Windows firewall. Run this in an Administrator cmd prompt or powershell. I forget where I "borrowed" this from but someone else had ...

View answer
Remove a node from Failover Cluster
0 votes

I have just evicted in the past, it will stop the cluster services for you.

View answer