No announcements
-
0 Votesa jobstep, in the secondary instance while it functions as secondary role, was configured to run in the scope of a mirrored database could be executed
we are running SQL server 2017 in our production environment with SQL mirroring to a secondary server. some of our jobs are designed with a first 'Check if principal' step that ...Unanswered | 1 Replies | 82 Views | Created by juniorkiran - Thursday, December 26, 2019 11:46 AM | Last reply by Cathy Ji - Friday, December 27, 2019 7:27 AM
-
0 Votes
Transtion Replication configure succesful but data not transfer
hi Transitions Replication configure successful but data not transfer, For testing proposed I have created table but table also not showing secondary ...Unanswered | 7 Replies | 298 Views | Created by ajit kumar1991 - Friday, December 20, 2019 11:09 AM | Last reply by Stan210 - Monday, December 23, 2019 10:00 AM -
0 Votes
I want to window server restart production (primary server ) impact of any log shipping primary server or secondary server(Reporting server) .
hi I want to window server restart production (primary server ) impact of any log shipping primary server or secondary server(Reporting server) ...Proposed | 2 Replies | 338 Views | Created by ajit kumar1991 - Thursday, December 19, 2019 7:02 AM | Last reply by Uri Dimant - Sunday, December 22, 2019 6:10 AM -
0 Votes
Need window server restart(primary server ) impact of logshipping primary server
hi I Need to window server restart(primary server ) impact of any log shipping primary server or secondary server. any impact let me ...Proposed | 7 Replies | 508 Views | Created by ajit kumar1991 - Thursday, December 12, 2019 6:03 AM | Last reply by Amelia Gu - Thursday, December 19, 2019 9:50 AM -
2 Votes
All Foreign Keys are disabled after turning on replication.
We recently added a SQL server to mirror our production database. Now we have 2 servers and the live database shows as (Synchronized). A user reported a problem and we realized ALL the ...Proposed | 9 Replies | 1382 Views | Created by MVPinFLA - Tuesday, November 26, 2019 11:26 PM | Last reply by MVPinFLA - Tuesday, December 3, 2019 1:48 PM -
0 Votes
DB snapshot taking more time on Mirrored database.
Hi Team, SQL is 2008R2+sp4 and window 2008R2. We have A(Source) and B(Dest) servers which is configured for the DB mirroring(say x db in A) everyday the ...Unanswered | 3 Replies | 714 Views | Created by S_NO - Monday, December 2, 2019 3:58 PM | Last reply by S_NO - Tuesday, December 3, 2019 8:37 AM -
0 Votes
Unable to telnet these ports 5022,5023
hi I am Unable to telnet these ports 5022,5023. NO any network side block, already open the port window fire wall but still not working. another server(2) side telnet ...Discussion | 2 Replies | 1180 Views | Created by ajit kumar1991 - Monday, November 18, 2019 4:39 AM | Last reply by Uri Dimant - Sunday, December 1, 2019 5:06 AM -
0 Votes
Database mirroring suspended
Hello, I have setup database mirroring between SQL 2016 (Principal) and SQL 2017 (Mirror). Then I failed over the databases from SQL 2016 to SQL 2017. Databases got failed over, but ...Answered | 1 Replies | 851 Views | Created by Vicky_SQL_DBA - Wednesday, November 27, 2019 12:47 PM | Last reply by KevinBHill - Wednesday, November 27, 2019 1:22 PM -
0 Votes
how to sql server mirroring in single user mode in production server
hi, how to sql server mirroring in single user mode in production server ajitkumarUnanswered | 5 Replies | 797 Views | Created by ajit kumar1991 - Friday, November 22, 2019 5:57 AM | Last reply by Robin Shanab - Monday, November 25, 2019 9:11 AM -
0 Votes
how many database mirroring in one server
hi I want multiple database mirror in same SQL server, but got error 1460. how many database mirroring in one ...Discussion | 2 Replies | 840 Views | Created by ajit kumar1991 - Thursday, November 21, 2019 11:30 AM | Last reply by Dharmendra Kr. Gupta - Thursday, November 21, 2019 3:35 PM -
0 Votes
how to configure 2 DC server(active /passive)cluster and 1DR server(Non cluster) mirroring in 2016 sql server
hi, how to configure 2 DC server(active /passive)cluster and 1DR server(Non cluster) mirroring in 2016 sql server with automatic ...Proposed | 2 Replies | 912 Views | Created by ajit kumar1991 - Friday, November 15, 2019 7:28 AM | Last reply by Cathy Ji - Monday, November 18, 2019 2:50 AM -
1 Votes
how to transfer the login one server to another server
hi In my company server hardware update , I how to transfer all logins , jobs, maintenance plan to another always on server ...Proposed | 5 Replies | 826 Views | Created by ajit kumar1991 - Thursday, November 7, 2019 6:09 AM | Last reply by Dedmon Dai - Friday, November 8, 2019 3:18 AM -
0 Votes
SQL DB mirror trigger failover upon principle DB failover (Microsoft failover cluster)
hi Guy, I have two set of SQL server 2016 running on Microsoft failover cluster in two sites, and have DB witness on 2nd site. When principle DB in 1st site ...Proposed | 3 Replies | 805 Views | Created by lywwing00 - Tuesday, October 29, 2019 3:56 PM | Last reply by Cathy Ji - Thursday, October 31, 2019 8:31 AM -
1 Votes
TFS Azure OnPrem server
Hi, We have two different TFS Azure OnPrem server on different disconnected networks. Is it possible to combine the DB of the two ...Answered | 1 Replies | 932 Views | Created by Eldadcohen - Monday, October 28, 2019 7:52 PM | Last reply by Cathy Ji - Tuesday, October 29, 2019 2:13 AM -
0 Votes
Error: 3624, Severity: 20, State: 1. A system assertion check has failed - on AG Secondary
Hi All, we have two node AG with the following configuration SQL Version : Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 ...Unanswered | 4 Replies | 964 Views | Created by Nuwan K - Monday, October 21, 2019 4:21 AM | Last reply by Shanky_621 - Thursday, October 24, 2019 7:07 AM -
0 Votes
my alert team send mail..reduce catch memory 39992>=90kb
=90kb Associate Threshold Profiles for SQL Cache Memory (KB), Critical Alarm if >= 80Warning Alarm ...Proposed | 5 Replies | 1013 Views | Created by ajit kumar1991 - Tuesday, October 22, 2019 7:31 AM | Last reply by Uri Dimant - Wednesday, October 23, 2019 6:39 AM -
0 Votes
I CANT CONFIG MIRRORING
Windows 10 Server 2016 Standard - Firewall fully disabled - SQL Server Standard Edition Stand Alone installed in both servers only selecting Database Engine ...Proposed | 5 Replies | 1068 Views | Created by J_R37 - Friday, October 18, 2019 9:36 AM | Last reply by Cathy Ji - Tuesday, October 22, 2019 9:55 AM -
0 Votes
Unable to see mirroring monitor
Hi, I Unable to see mirroring monitor data transfer history. Data syns principle to mirror server but in the mirror monitor data transfer not ...Proposed | 1 Replies | 1226 Views | Created by ajit kumar1991 - Saturday, October 19, 2019 11:08 AM | Last reply by Cathy Ji - Monday, October 21, 2019 2:59 AM -
0 Votes
Cloud you please help me for mirror monitor the database data transfer properly mirror server ?
Cloud you please help me for mirror monitor the database data transfer properly mirror server ? & how to access mirror database in read mode because this is not accessible ...Proposed | 2 Replies | 904 Views | Created by ajit kumar1991 - Wednesday, October 16, 2019 12:45 PM | Last reply by Amelia Gu - Thursday, October 17, 2019 7:15 AM - Items 1 to 20 of 2872 Next ›
No announcements
