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 | 77030 Views | Created by Paul Randal - Saturday, June 3, 2006 4:25 PM | Last reply by Markwillium - Friday, February 22, 2013 6:34 AM
Found 9691 threads
-
2 Votes
Log shipping secondary database created in the wrong location (2008 r2)
Primary SQL Server 2008 r2 Secondary SQL Server 2008 r2 Secondary Database Default locations; Data: D:\SQLData Log: ...Answered | 7 Replies | 6982 Views | Created by Eric Labashosky - Wednesday, September 24, 2014 8:50 PM | Last reply by cjmorgant1101 - Tuesday, August 25, 2020 4:56 PM -
0 Votes
How to verify Quorum Configuration in Win Server 2016?
Get-ClusterQuorum |fl Gives Cluster : ClusterName QuorumResource : File Share ...Answered | 7 Replies | 4793 Views | Created by SQLRocker - Tuesday, August 4, 2020 11:21 PM | Last reply by Cathy Ji - Thursday, August 20, 2020 7:49 AM -
2 Votes
Database showing unexpected ‘LOG_REUSE_WAIT_DESC’
A database which was removed from AlwaysOn configuration is showing ‘LOG_REUSE_WAIT_DESC’ as ‘AVAILABILITY_REPLICA’ which led the database log to be get ...Proposed | 6 Replies | 3692 Views | Created by Sreekanth Madambath - Wednesday, August 5, 2020 3:15 PM | Last reply by Amelia Gu - Wednesday, August 19, 2020 9:27 AM -
0 Votes
Restore operation failing in VSS return sVSS_E_OBJECT_NOT_FOUND
SetAdditionalRestores(myWriterId, VSS_CT_FILEGROUP, logicalPath, compName, true)); and this is the response it is returning. INFO: VSS: ERROR: ...Unanswered | 7 Replies | 3831 Views | Created by Shvm123 - Wednesday, August 12, 2020 10:08 AM | Last reply by Sreekanth Madambath - Tuesday, August 18, 2020 4:07 AM -
0 Votes
What does the repair button in the Listener object do in the Failover Cluster Manager.
Hello. We had an issue where one of our AG's failed over and failed to obtain the IP for the listener and the AG went into a "Resolving" state. Thus the databases were ...Unanswered | 2 Replies | 4583 Views | Created by DBA_Bandy - Friday, August 14, 2020 5:54 PM | Last reply by Amelia Gu - Monday, August 17, 2020 2:44 AM -
2 Votes
SQL 2016: Convert Standalone Server to Single Node Cluster - SQL Server Availability Group
Hello, I have a standalone server running on Windows Server 2012 R2 with SQL 2016 already installed. I would like to convert this standalone server to a single ...Proposed | 7 Replies | 6199 Views | Created by bs2020 - Friday, July 31, 2020 9:58 PM | Last reply by Cris Zhan - Monday, August 17, 2020 1:23 AM -
1 Votes
Adding database back to AG
we removed databases from AG. To add back the database to AG, should we add it primary replica and go to secondary replica and join the database there?Or is it enough to add it in primary ...Answered | 6 Replies | 3582 Views | Created by juniorkiran - Friday, August 14, 2020 4:47 AM | Last reply by Cris Zhan - Monday, August 17, 2020 1:07 AM -
0 Votes
AlwaysOn cluster break
In case cluster break due to loss quorum where all secondary replica is down and left is only the primary . The database in primary replica will be not synchronizing. One way to bring it back database ...Unanswered | 4 Replies | 3695 Views | Created by Mario2286 - Monday, August 10, 2020 10:59 AM | Last reply by Shanky_621 - Saturday, August 15, 2020 1:40 PM -
0 Votes
Licensing for a failover server
We're looking to purchase SQL Server and were wondering what the licensing would look like for a production server + backup. The backup server would contain a full copy of all databases but wouldn't ...Unanswered | 4 Replies | 3556 Views | Created by DisplayN4me - Monday, August 10, 2020 9:25 PM | Last reply by Shanky_621 - Saturday, August 15, 2020 1:25 PM -
1 Votes
Download SQL 2019 FCI images
I would like to know if I can download a SQL 2019 FCI images (not availability groups) . Are there images that I can download (VMWare HyperV, anything..) ? For ...Proposed | 3 Replies | 2879 Views | Created by SeHor - Tuesday, August 11, 2020 11:05 PM | Last reply by Alex Bykovskyi - Friday, August 14, 2020 10:28 AM -
0 Votes
start-cluster needed after stop-cluster?
Get-ClusterResource | select ...Answered | 5 Replies | 3706 Views | Created by SeHor - Friday, August 7, 2020 11:35 PM | Last reply by Cathy Ji - Monday, August 10, 2020 7:33 AM -
0 Votes
Database Mirroring automatic failover
Hi, I am considering implementing Database Mirroring on SQL 2019 standard edition. I need automatic failover, so will need ...Unanswered | 9 Replies | 4006 Views | Created by Zoe.Ohara - Tuesday, August 4, 2020 9:43 AM | Last reply by MIAOYUXI - Monday, August 10, 2020 3:07 AM -
0 Votes
Auto-seeding on Secondary AG replica
I encountered an issue when creating new secondary node for AG on SQL Server 2019 EE and used automatic seeding. Some data files created on the same drives as Primary (this is correct), but some data ...Unanswered | 9 Replies | 4012 Views | Created by Vadim Sudenko - Wednesday, August 5, 2020 7:34 PM | Last reply by MIAOYUXI - Monday, August 10, 2020 2:02 AM -
2 Votes
Lost MDF file
Hello everyone, Recently, I accidentally deleted my database mdf file. I have database backup (full and log file) everyday. ...Answered | 6 Replies | 3639 Views | Created by Piseth Ben - Friday, August 7, 2020 6:39 AM | Last reply by Sreekanth Madambath - Friday, August 7, 2020 4:55 PM -
0 Votes
One of the databases backed up BUT then fails to complete the command Backup Database. Others fine.
The environment is AlwaysOn Sql for sql 2014. The backup tool is netbackup. All the databases are being backed up in the group. However, for one database the message first is ...Unanswered | 5 Replies | 4602 Views | Created by SaggitariusA - Tuesday, August 4, 2020 1:51 PM | Last reply by Amelia Gu - Friday, August 7, 2020 9:37 AM -
1 Votes
Distributed availability group on the Azure VM's
Hi , I was looking for documentation to setup distributed availability group on the Azure VM's , I looked at msdn site but couldn't find anything specific to azure distributed ...Proposed | 3 Replies | 3747 Views | Created by sangem18 - Sunday, August 2, 2020 7:38 AM | Last reply by Cris Zhan - Friday, August 7, 2020 8:39 AM -
0 Votes
SQL 2016 always between two datacenter
Hello, I need your help to understand how the distributed AG works betwenn data centers. here is what I need to impliment: 2 datacenters ...Unanswered | 2 Replies | 3451 Views | Created by virtugeek - Thursday, August 6, 2020 3:42 PM | Last reply by Amelia Gu - Friday, August 7, 2020 7:07 AM -
0 Votes
my Disney Magic Kingdoms will not work and has been deleted I want to restore
I was guided to ask here how to find my game stored in Miccrosoft From Gameloft............After investigating your account, we found out that your progress level 50 is saved on ...Unanswered | 2 Replies | 3734 Views | Created by Kernowmaid - Thursday, August 6, 2020 4:44 PM | Last reply by Cris Zhan - Friday, August 7, 2020 1:30 AM -
0 Votes
Replace node sql failover cluster with different language
Hi all. I have a failover clustering with win2019 and sql 2014 ent. OS and sql are in italian language. I want replace all node, one to one with same OS and same sql but in eng. ...Unanswered | 3 Replies | 3704 Views | Created by FromRome - Wednesday, August 5, 2020 9:45 AM | Last reply by Shanky_621 - Thursday, August 6, 2020 12:03 PM -
0 Votes
How to find latency b/w Primary and Secondary in Always ON
We have SQL 2016 with Always on (i.e., Asynchronous). How to find out (through T-SQL) what the is latency b/w Primary and Secondary node and how much time it would take to ...Unanswered | 4 Replies | 5149 Views | Created by XYZ001 - Tuesday, August 4, 2020 4:52 AM | Last reply by MIAOYUXI - Thursday, August 6, 2020 1:22 AM - Items 1 to 20 of 9691 Next ›
No announcements
