Rename databases part of AlwaysOn Group
Hi Experts, I have few databases which are part of Alwayson Group, Can I rename the database?
2017-04-25
4,797 reads
Search results for "availability+groups"
Your search for "availability+groups" returned 100 results:
Read Scale Availability Groups and Listner
Is it possible to use a listener with a read scale availability group? I have read on some sites you cannot use one but in others that you can. If so what IP addresse do you use for it? I have tried to assign a new one in the subnet and also using the IP […]
2019-07-26
307 reads
recreate a Basic Availability Group question
hi, In the process of changing IPs for one node of a clustered server with databases in a Basic Availability Group we have to drop and recreate the BAGs.Working on the node where the BAG is primary we delete the BAG from the Availability Groups, this would result with the database on the secondary node […]
2019-03-01
121 reads
Domain-Independent Availability Groups without DNS Server
Hi there, Just wondering if anyone knows whether it's possible to create Domain-Independent Availability Groups on a WSFC without having a DNS server? Every guide I've found seems to require a separate DNS server, whereas I'm wondering if simply adding all the required IP addresses for each resource into the hosts file on each node […]
2022-11-03
56 reads
How to Set Up Standard Edition Always On Availability Groups in ...
Mar 5, 2017 ... Enable AlwaysOn Availability Groups on Each Server. On each replica, launch SQL Server Configuration Manager, then go into SQL Server Services, ...
Availability groups and sql agent
I have A proof of concept 2019 sql server with 2 active nodes and a read only reporting node. I'm looking at the SQL agent jobs and don't want them to fire on both nodes - i know the jobs need to be on both nodes for a failover scenario so my plan was to […]
2020-03-02
142 reads
Availability Group Replica Disconnected
I am configuring Distributed Always on Availability groups. I joined my secondary AG to the group using the following script (edited of course) and it ran without issues. but when I look under the distributed availability group available replicas it is showing disconnected. I am unaware of anything i can do to kick it or […]
2020-06-11
435 reads
Availability Group database went into 'Restoring' state
Dear Friends, Please advise why would one of my Availability Group databases go into 'Restoring' state. Thanks in advance.
2023-06-01
867 reads
SQL Server 2016: Availability Groups, Direct Seeding, and You ...
Feb 9, 2017 ... The script itself is simple, though. I'm going to create my Availability Group for my three lovingly named test databases, and add a listener.
Refresh databases that belongs to Availability Group using dbatools
Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed...
2020-06-03 (first published: 2020-05-20)
1,027 reads
Blogs
Are ABORT_AFTER_WAIT's victims logged?
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
Part 2: The Modern Azure Data Warehouse – ADF and ADLS
In today’s data-driven world, having the right tools to manage and process large datasets...
A New Word: Flichtish
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Forums
Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors
I took a backup with the CHECKSUM option, which was successful and showed no...
Realities of Predictive Analysis
Comments posted to this topic are about the item Realities of Predictive Analysis
Linked Server Product Name?
Just came across something weird. Was wondering if anyone else has ever seen this....
Question of the Day
Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers