132 questions
0
votes
0
answers
27
views
Mirroring - Server network address can not be reached or does not exist (Error: 1418)
I would like to mirror the database I have in my local desktop (192.168.0.80) on my local mini pc (192.168.0.85) that will be on 24 hours a day.
This mini pc will only be used as a consultation for my ...
- 188
0
votes
1
answer
3k
views
Exception during db mirroring failover to SQL Server 2022 from previous version
To perform upgrade of production DB cluster from the current SQL Server 2014 to the new SQL Server 2022 without downtime, I use DB Mirroring approach:
Primary node - SQL Server 2014 Std (v12.0.6439.10,...
- 21
1
vote
2
answers
438
views
GCP Database migration service for Postgres - how to migrate a database with a name other than "postgres"?
I'm trying to do a database migration using GCP Database Migration Service
My source database is of Postgres type (hosted on Heroku), but the name of the database is not postgres but rather something ...
- 2,799
0
votes
1
answer
2k
views
MySQL Replication VS Mirroring and how to do both?
MySQL Replication VS Mirroring and how to do both, does anyone knows some information on this topic?
- 121
0
votes
1
answer
454
views
How to do Delayed Replication on MySQL 8?
I made replication for MySQL 8 just like in the documentation:
https://dev.mysql.com/doc/refman/8.0/en/replication.html
But I cant make a 17.4.11 Delayed Replication. I suppose before it was easy: 17....
- 121
0
votes
0
answers
160
views
Sending SQL alert when WITNESS is disconnected
I'm looking for some help setting an alert to fire when the 'mirroring_witness_state_desc' in the following query returns a 'DISCONNECTED' value. We've had incidents where the WITNESS server will ...
- 53
0
votes
1
answer
642
views
How to do mirroring or replication in table level in SQL Server with SQL Query
Inserting one row from one table to another table of second database
Insert into Task1.dbo.Patients (FirstName, Lastname, Address, ContactNo,Gender,DateOfBirth )
Select FirstName, Lastname, Address,...
- 193
1
vote
0
answers
70
views
The Mirror Monitoring Log contains a gap of several hours - why?
I am running mirroring on several databases on a SQL Server 2008 R2 system (I know, don't judge me).
I ran this to look at the mirroring log
EXEC sp_dbmmonitorresults
GANDALF, --database
4, ...
1
vote
1
answer
5k
views
'distributor_admin' is not defined as a remote login at the server, login failed for user 'distributor_admin'
I am distributing Database data on SQL Server, I am using Replication but until this picture, I have an error.
I have tried the methods on the internet by that sp_dropserver and sp_addserver are the ...
-1
votes
1
answer
536
views
SQL Server 2016 Standard - High performance (async) mirroring
I have a SQL Server 2016 Standard Edition. I would like to mirror a database to a server which is located far away.
Currently a scheduled script creates backups and then uploads them to another server....
- 345
0
votes
1
answer
664
views
Using DFS-R instead of mirroring on SQL Server
I want to do mirroring on SQL Server. While mirroring is better, only Enterprise can do this and the licence cost is an issue. I can use SQL Server standard which allows DFS-Replication not mirroring.
...
- 375
5
votes
1
answer
4k
views
Set database to single user mode for database involved in database mirroring session or an availability group
I'm trying to set a database to single user mode that is currently in an availability group or in a mirroring session. But i'm getting the following error:
The operation cannot be performed on ...
- 572
1
vote
1
answer
77
views
Mirror Relational Databases to RethinkDB?
I found this article Sync Relational Databases to NoSQL like MongoDB and was sad to see only MongoDB on the dropdown list:
Is it possible to sync a relational database to RethinkDB with SymmetricDS ...
- 3,649
0
votes
0
answers
46
views
SQL How to make principle db mirror and mirror db principle
I need to temporarily set up Idera SQL Compliance manager for the mirror database. but, the mirror database is not showing the required database since its being mirrored. So I am guessing I need to ...
- 75
0
votes
0
answers
3k
views
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State
Error Log Generated this Error:
An error occurred in a Service Broker/Database Mirroring transport
connection endpoint, Error: 8474, State: 11. (Near endpoint role:
Target, far endpoint ...
1
vote
0
answers
55
views
How to set up database mirroring and failover?
I want to do the database mirroring and failover for my application. I don't know where to find the resource or information about that. so if you used to work on that please recommend me any site or ...
- 53
2
votes
2
answers
496
views
Which is the fastest way to create a test database(with all data) from a production database which is quite big in size (400 GB)?
I am a java person and not so much familiar with Oracle available features. Please help me.
The requirement is that, we are looking for some virtual(replica/mirror/view) database to be created from ...
- 589
0
votes
0
answers
86
views
SQL Server effectiveness of mirroring partial database
Our database stores 200 TB of data. We've setup clustering options of two VM nodes with one storage but due to limited resources, we cannot replicate the entire database for disaster recovery (only ...
- 3
0
votes
0
answers
278
views
mysql apply only required changes
I have 2 DB instances running on dev and prod.
In dev I have created a table students with the following schema
create table students (name varchar(20), age int, place varchar(100));
I created the ...
- 708
0
votes
0
answers
38
views
Server Architecture for application that needs to have country code top level domain
I was working on an web and mobile application which was startup business of Australia. We have our linode server and database in Singapore. We have a separate codebase for web app and mobile app(APIs)...
- 353
1
vote
0
answers
142
views
Transaction log filling the drive if mirroring fails
I am having two mirrored SQL Server 2016 machines with mirroring set up. This is supposed to be hot-standby scheme.
HDD size is 1TB, and database size is around 600GB (just one DB). This is 90 days ...
- 11
0
votes
0
answers
39
views
Can I run specfic scripts in multiple DB server?
I am using flyway for Database migration and want to achieve the following scenario :
I have one use case in which I need to fire all scripts in single SQL DB server except one script which needs to ...
- 385
0
votes
0
answers
728
views
SQL Server 2016 Mirroring failed, but database is in Recovery state
I'm trying to setup mirroring in SQL Server 2016 using SSMS, but it's not working. It's failing, and after a lot of retries still I'm not able to set this up. Post restoring backups the database state ...
- 967
1
vote
0
answers
29
views
After manually fail over resume button is disabled and query doesn't resumes
As there is no witess available, so when resumes the mirrored database by
ALTER DATABASE <database_name> SET PARTNER RESUME;
does not resumes the mirroring. Resume button is also disabled. I ...
- 570
0
votes
0
answers
55
views
How to implement database mirroring using SQL on two geographically separate servers
Good Day
I need to implement database mirroring on two geographically separate servers.
I have been tasked with ensuring that there should be a backup of the databases that is not more than 1 day ...
0
votes
0
answers
249
views
2 way sync of MySQL databases
A web application runs both on live and local server with live and local database server. Users use live server to add the data, whereas internal staffs use the local application to update the data. ...
2
votes
1
answer
134
views
SQL DB Mirroring
I have two SQL 2016 servers configured in a mirror with a witness. We've been running some failover tests and every test has succeeded except the following two scenarios. Does anyone know why these ...
- 67
2
votes
1
answer
1k
views
Automate MySQL DB to update tables on remote server from localhost continuously
I am a newbie and hence need some advice.
My problem is similar to this question but I couldn't resolve the problem yet.
Problem:
I am processing data internally and generating 8-10 tables. I want ...
- 67
0
votes
0
answers
607
views
MS-SQL 2012 Principle "Freeze"
yesterday I had a "freeze" of one of our customers mirrored database.
The symptom was that all applications freezed.
There was no high cpu (~1% for the sql server and ~10% total) / memory (4GB free ) ...
- 1,165
0
votes
1
answer
511
views
Mirror table vs materialized view
From this excellent video "Microservices Evolution: How to break your monolithic database by Edson Yanaga" I know that there are different ways to split chunk of data as separate db for microservice:
...
- 45.7k
2
votes
1
answer
3k
views
The process could not connect to Subscriber 'xxxxxx'
i have configured transnational push replication from SQL Server 2014 to Azure SQL Database
publisher DB is also configured for mirroring.
i get The process could not connect to Subscriber 'xxxxxx'
...
- 1,507
1
vote
0
answers
70
views
SQL Server mirror at night, available by day
I have a large (~200GB) database on server SQL-PROD. This is a production database with highly restricted access.
I want to have a copy of the database for developers to use for testing on server SQL-...
- 61
0
votes
0
answers
265
views
Suspend/Resume SQL database mirroring by C#
I want to implement a Windows Scheduler job which suspense/resume the database mirroring sessions on a fixed period. Is this able to use C# code sending T-SQL query to suspense/resume mirroring ...
- 561
3
votes
0
answers
489
views
error during Django 1.8 test with multiple databases
I'm moving a Django 1.8 project from a single database setup to a writer/reader setup. I ran into the issue described in Django bug 23718 but the work arounds described didn't seem to help.
Has ...
- 79
0
votes
1
answer
659
views
SQL Server Replication with Publication and Subscriptions not working as it requires the actual server name to make a connection
I have a Computer / SQL Server machine that ALL software ( 500 applications) know as TMPSQL2
So on this TMPSQL2 machine I have a Database that I want to setup replication with doing Publication.
...
user6321478
0
votes
1
answer
3k
views
Replicating a SQL Server database for reporting purposes
I am trying to determine the best way to replicate a SQL Server database from its production environment to another server for reporting purposes.
A cloud-based software application we use is based ...
- 13
0
votes
0
answers
1k
views
SQL Server mirroring connection issue
Server A : Win 2008, SQL Server 2012, IP : 1.1.1.1 (Principal)
Server B : Win 2008, SQL Server 2012, IP : 2.2.2.2 (Mirror)
2 servers are not on the same LAN, no domains, so I need to use IP for ...
- 73
0
votes
0
answers
1k
views
Microsoft SQL Server Error 1475
Could anybody help me please.
I am trying to mirror our SQL Server 2005 to our DR site. I have successfully done half of the databases without any issues.
However, the remaining ones all have the ...
- 1
0
votes
1
answer
801
views
Is FlywayDB or Liquibase used for Cross DB Migration?
I'm working on a project, which is planned to use/manage 3 different databases [MySQL, SQL Server, Oracle] as the back-end. Now I have finished with my database design and everything I have set in ...
- 1
4
votes
1
answer
30k
views
Operation cannot be performed on database because it is involved in a database mirroring session or an availability group (Azure)
I am experiencing an intermittent issue with SQL Azure. I am copying a readonly SQL Azure database (V12) from one elastic pool into another. Once the database is copied, I set it to read/write using:
...
- 655
0
votes
1
answer
266
views
Db fail over in Mirrored environment causing connection attempts from web app to fail until the application pool is restarted
I have a mirrored sql server db environment. A load balanced application hosted in IIS is accessing the databases. In Connection string I have mentioned FailOver partner. When I am performing fail ...
- 1,525
0
votes
1
answer
334
views
Running against intensive queries the mirror database
For SQL Server 2012 Enterprise Edition, we have a mirrored database named X1. We can query the secondary DB. I would like to extract data from this secondary mirrored database (X1) with SELECT queries ...
- 476
1
vote
0
answers
114
views
Run query from one database to another in SQL Server Mirroring set up
We have two databases on SQL Server 2008 R2. These databases are both mirrored to a second server. DB1 runs a SELECT query on DB2.
The query assumes that DB1 and DB2 are on the same DB server, but ...
- 3,969
2
votes
2
answers
20k
views
How to specify port in JDBC connection URL for failoverPartner server in SQL Server
I'm trying to add a server as a failover for SQL Server and it is not using the port 1443, I'm using the port 2776. I'm trying to specify it but everything I tried didn't work. How could I do that?
...
- 1,336
1
vote
0
answers
2k
views
The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database
We have two SQL 2012 database servers configured in a mirror with a witness for automatic fail-over.
Yesterday the primary server suffered a HDD degradation which triggered the fail-over, however ...
- 8,968
1
vote
0
answers
337
views
SQL Server mirroring_partner_instance does not have FQDN
There are two SQL Server instances with mirroring setup. ServerA is primary and ServerB is mirror. Below is my connection string
jdbc:sqlserver://ServerA.company.com\\AB002;portNumber=23112;...
- 29.3k
1
vote
0
answers
852
views
SQL Mirroring. Error while configuring SQL Server -The remote copy of database "Mirroring" does not exist
While configuration SQL server mirroring I got below error.
I started SQL Server and Analysis services with same account on both servers. SQL server Agent service also started in both servers but ...
- 11
1
vote
1
answer
582
views
Postgres Asynchronous replication
i have an RoR application working with a Postgres database. This is working in a local computer for local network clients. But i want to add a database on the cloud mirroring the local database. But ...
- 345
0
votes
1
answer
883
views
How long does a sql mirror failover take to complete?
We are mirroring our database and I would like to know how long it would take to complete a failover from the time that I click "failover" in sql?
- 25
0
votes
1
answer
523
views
Mirror database between different Azure Accounts
We have two different Azure Accounts with each having a set of databases.
Now, there is one database that we need to access in both the accounts with joins involving local tables (Especially one huge ...
- 135