Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 105076

Availability Groups are a new feature of SQL Server 2012 that provide continuous data synchronization, automatic failover and secondary read access for one or many SQL Server databases.

0
votes
1answer
What is the proper way to create logins on Always on? An application database requires an active directory login and I created that on the primary node. The database is still not in the availability …
asked Dec 19 '16 by user2923332
1
vote
0answers
I am planning to add 3 new databases to an existing AAG cluster in a VM. The AAG has Veeam databases on it as of now. Veeam backups are not running on it as of now apart from a couple of batch process …
asked Oct 4 '16 by user2923332
0
votes
1answer
If I understood the configuration of setting up a multi subnet AG setup where 2 nodes are in one datacenter and the 3rd node in another, I was under the assumption that we require 2 listner ip's - 1 l …
asked Dec 27 '16 by user2923332
3
votes
2answers
We are planning to expand an existing AAG setup which is a 2 node setup in DC and will be adding a 3rd node in San Jose(different subnet). The current setup is configured with Node and File Share majo …
asked Feb 21 '17 by user2923332
1
vote
3answers
I went through this link on stack exchange and also Brent Ozar's . I don't plan to create any differential backups for the AAG group. Can you please let me know if enabling this option should work. I …
asked Oct 14 '16 by user2923332
-1
votes
4answers
I have to create a new database for a company wide printing application.Since there is not much overhead, we are planning to use an existing SQL Setup for the same. Can someone suggest when can I actu …
asked Sep 19 '16 by user2923332
1
vote
2answers
How can I take backups of databases that are not present in Availability Groups? Can I use a single maintenance plan for both AG dbs and non AG dbs? Should the copy_only option be enabled for non AG …
asked Mar 29 '17 by user2923332
0
votes
1answer
I have setup with FCI+AG solution but with independent disks. There is no listener, and the applications are connecting to the FCI. Is this setup even reasonable to use? The only option I see here is …
asked Dec 20 '16 by user2923332
1
vote
0answers
I created implementation steps with fallback plan to add a database to an existing Always On availability group.Can someone please take time and go through the steps and let me know if this everythin …
asked Oct 3 '16 by user2923332
1
vote
1answer
I have a 2 node Always On Availability Group cluster where we are planning to take backups to a file share which will then be moved to Azure cloud. We have a service account from the Windows team for …
asked Nov 18 '16 by user2923332
3
votes
1answer
I am planning for a "multi-subnet" AG group . 2 at the primary data center in DC and one at San Jose. We are planning to test a vendor application which requires SSIS. I am planning for the SSIS to b …
asked Apr 3 '17 by user2923332
2
votes
2answers
I configured Ola's scripts on a staging AG configuration to test out the logic. When I checked the backup folder today after a week, I see that the backups are happening both on the primary replica an …
asked May 17 '17 by user2923332
0
votes
1answer
I have configured a 2 node AAG setup with named instances say N1 and N2. During the AAG creation and database seeding from N1 , I got an error saying that N2 did not have any folders/path similar to N …
asked Aug 31 '17 by user2923332
0
votes
1answer
If I am having a multisite AG with 2 nodes in the primary datacenter and 2 nodes in the DR - Where can I place the quorum for its continuous availability? I am assuming a 3rd site - but my management …
asked Mar 14 '17 by user2923332
0
votes
Haider, the db which I created is on the primary node outside the AAG. For installing the application should I be giving the server ip or the cluster ip ? Thanks
answered Dec 12 '16 by user2923332

15 30 50 per page