No announcements
-
3 VotesWelcome to the SQL Server Disaster Recovery and Availability Forum
(Edited 8/14/2009 to correct links - Paul) Hello everyone and welcome to the SQL Server Disaster Recovery and Availability forum. The goal of this Forum is to offer a gathering ...Sticky | 5 Replies | 67388 Views | Created by Paul Randal - Saturday, June 3, 2006 4:25 PM | Last reply by Markwillium - Friday, February 22, 2013 6:34 AM
-
1 Votes
Adding a 2.5TB database to a SQL 2014 Ent AOAG
Hi We have several databases that are members of an AOAG running between two MS SQL Server 2014 Ent instances. We wish to add another database but it's 2.5TB in size. ...Unanswered | 3 Replies | 278 Views | Created by BIT Solutions - 1 hour 29 minutes ago | Last reply by Hilary Cotter - 29 minutes ago -
0 Votes
Cluster resource 'SQL Server' of type 'SQL Server' in clustered role 'SQL Server (MSSQLSERVER)' failed.
Hi, I created a 2nodes SQL Server cluster. but SQL Server is down when I manually restarted one node. below is the detail: Cluster resource ...Unanswered | 2 Replies | 42 Views | Created by Sajidami82 - 7 hours 47 minutes ago | Last reply by Hilary Cotter - 40 minutes ago -
0 Votes
Getting encryption error during DB restore
Hi, I am getting below error while restoring one database. Error: 28054, Severity: 11, State: 1. Service Broker needs to access the ...Unanswered | 2 Replies | 129 Views | Created by Arup.mca - Friday, October 4, 2019 3:25 PM | Last reply by Amelia Gu - Monday, October 7, 2019 8:26 AM -
0 Votes
Adding the (Read Only) node to the existing cluster
I am trying to add a node to the existing cluster by using SQL Server Installation Center choosing option "Add a node to SQL Server fail-over cluster" . It passes all the add node ...Unanswered | 6 Replies | 188 Views | Created by Nidhi Dham - Friday, October 4, 2019 4:19 PM | Last reply by Cathy Ji - Monday, October 7, 2019 7:50 AM -
0 Votes
R Services to add on existing SQL server Cluster
I am trying to add new feature as R service in Database feature for an existing SQL server failover cluster configuration for 4 node cluster. I did try to add feature to install R services and it did ...Proposed | 1 Replies | 118 Views | Created by Manuji - Sunday, October 6, 2019 1:24 PM | Last reply by nkumar230 - Sunday, October 6, 2019 3:10 PM -
0 Votes
Client gets "Remote harden of transaction X failed" error when AlwaysOn failover occurs
We have an AlwaysOn Availability Group, with 3 nodes, one database, running SQL Server 2012 SP1 on Windows Server 2012 R2. We have a client application written in C++, that uses SQL Native ...Answered | 6 Replies | 11432 Views | Created by HeatherK - Thursday, May 29, 2014 3:10 PM | Last reply by Mohamed Mamdouh El Sayed (DBA) - Sunday, October 6, 2019 9:45 AM -
13 Votes
MDF & LDF files last modified date not increasing as expected
Hi, I have a SQL 2005 database whose restore model is set to simple. This is because there will not be many changes to the data, usually just once per week or occasionally ...Answered | 7 Replies | 31287 Views | Created by danzawo - Wednesday, November 5, 2008 8:12 PM | Last reply by Olaf Helper - Friday, October 4, 2019 8:14 AM -
0 Votes
Not able to uninstall cluster instance.
cluster does not support node names with more than 15 characters! Now "0" is 15th character and "1" which is missing is 16th ...Answered | 6 Replies | 670 Views | Created by PeterBB8 - Monday, December 10, 2018 7:16 AM | Last reply by PeterBB8 - Friday, October 4, 2019 1:08 AM -
0 Votes
AlwaysOn hide database replication
Hi all. I have a cluster with two node and two availability group. Each availability group has a listner. When i connect to these two listner ...Proposed | 2 Replies | 128 Views | Created by FromRome - Thursday, October 3, 2019 2:32 PM | Last reply by Dmitri Korotkevitch - Thursday, October 3, 2019 5:17 PM -
0 Votes
Secondary node corruption for SQL 2008 R2 Cluster
Hi Experts, In my environment having an active passive cluster for SQL 2008 R2 on windows 2008 R2. The sec node is corrupted and needs to be redeployed i.e OS ...Answered | 1 Replies | 99 Views | Created by VG2014 - Thursday, October 3, 2019 11:39 AM | Last reply by Shanky_621 - Thursday, October 3, 2019 3:23 PM -
0 Votes
scom database in sql always on not accessible and not synced in primary and secondary
Dears, Posted this in SCOM section, they redirected me to sql section as the issue appears to be on sql level Appreciate your advice ...Unanswered | 5 Replies | 180 Views | Created by eg1559 - Wednesday, October 2, 2019 8:11 AM | Last reply by JoslynAhlgren - Thursday, October 3, 2019 9:00 AM -
0 Votes
How to detect client hits if they are coming thru or hitting the Listener instead of hitting primary or secondary server directly in AG
We have two node Availability Groups: Node A (ip address) Node B (ip address) Listener L (own ip address) Connection strings ...Proposed | 1 Replies | 293 Views | Created by Travis McGee - Wednesday, October 2, 2019 5:54 PM | Last reply by Dedmon Dai - Thursday, October 3, 2019 6:59 AM -
1 Votes
How to truncate the logs of MS-SQL database participating in Always-On Availability Group
We would like to Truncate the logs of MS-SQL database participating in Always-ON availability group. What is step by step guide or procedure to truncate the MS-SQL ...Proposed | 8 Replies | 211 Views | Created by Asif-Janjua - Tuesday, October 1, 2019 10:28 AM | Last reply by Shanky_621 - Thursday, October 3, 2019 6:16 AM -
1 Votes
SQL Server Basic Availability Groups - SQL Server 2016
Good morning, I'm looking to deploy Basic Availability Groups on SQL Server 2016. Here is my scenario: 1- I have a 2 nodes-Vmware ...Proposed | 5 Replies | 207 Views | Created by Gaëtan JACQUEMIN - Tuesday, October 1, 2019 8:47 AM | Last reply by Dedmon Dai - Wednesday, October 2, 2019 6:24 AM -
0 Votes
AAG Backups in SQL Sever Developer Edition
Hi , I am testing SQL Server Always ON backups in my Dev env which is a SQL Server Developer Edition through SSMS Maintenance Plans, but can't see any backups created ...Proposed | 3 Replies | 177 Views | Created by Raje14 - Tuesday, October 1, 2019 5:28 AM | Last reply by Dedmon Dai - Wednesday, October 2, 2019 6:15 AM -
0 Votes
How do you find the last uniquifier that was used for "null" values in a clustered index column?
We have had a couple of sites now that have had the error message basically stating we had run out of uniquifiers on this one table's clustered index. In this table there is a ...Answered | 4 Replies | 307 Views | Created by OutThere - Sunday, September 29, 2019 8:40 PM | Last reply by OutThere - Wednesday, October 2, 2019 12:40 AM -
2 Votes
Always on issue
Hi All, Can anyone who know Alwayson help me . Today morning, the AG wasn't available. But when the users came to me and checked the AG dashboard, it was ...Answered | 5 Replies | 273 Views | Created by Samantha v - Friday, September 27, 2019 9:17 PM | Last reply by Samantha v - Monday, September 30, 2019 5:00 PM -
1 Votes
Does Database Mirroring recover automatically from a server restart?
Hi! I have two old SQL 2008 instances on physical servers, that have mirrored databases on them. The server team are planning to restart both servers.. Do I need ...Answered | 2 Replies | 183 Views | Created by Zoe.Ohara - Monday, September 30, 2019 10:03 AM | Last reply by Zoe.Ohara - Monday, September 30, 2019 10:31 AM -
0 Votes
Large number of jdbc connections with SQL Server Always On configuration
We are facing a problem in a java based application where the number of database connections to a SQL server database is always increasing. The database is configured in a HA group and the ...Unanswered | 4 Replies | 286 Views | Created by adpurohit - Wednesday, September 25, 2019 6:31 PM | Last reply by Dedmon Dai - Monday, September 30, 2019 6:21 AM -
0 Votes
Converting primary key id column from int to bigint in AG VLDB database
Hi I have a VLDB database (3.2 TBs) that is an Availability group that is going to run out of ids soon on a couple of tables. I need to check but I am guessing at least one of ...Unanswered | 2 Replies | 472 Views | Created by OutThere - Wednesday, August 14, 2019 4:48 AM | Last reply by OutThere - Sunday, September 29, 2019 8:12 PM - Items 1 to 20 of 9374 Next ›
No announcements
