All Questions
Tagged with sql-server-2017 replication
18 questions
1
vote
0
answers
175
views
Altering the column without sysadmin or db_owner roles in published tables
I am using replication between two MS SQL Servers (2017 14.0.3421.10).
Unfortunately, when replication publishing is switched on, my user for database schema changes is not able to ALTER any columns. (...
- 111
2
votes
1
answer
6k
views
must be enable as a Publisher
I installed SQL Server 2017 on Centos 7 and used MSSM GUI for database replication configuration.
when the distribution configuration process was successful until the end but when creating a publisher,...
- 21
0
votes
1
answer
125
views
Replication reverted partitioned table to primary filegroup, can I re-link to the partitions?
We have 2 servers:
Server A. production (no partitions)
Server B. New Server (partitions and compression)
We restored a backup to the new server, partitioned a large table by datetime and turned on ...
- 301
0
votes
1
answer
135
views
can you setup replication on mirrored SQL database
Just moved to SQL2017 Ent. Currently, do transactional replication for 1.5TB DB. the replicated database is used for data analytics, mainly Power BI reports. Need near real-time data. When I have ...
- 1
0
votes
1
answer
321
views
Transactional Replication between SQL Server 2017(Publisher+Distributor) and SQL Server 2019(Subscriber) [closed]
So here's the replication scenario that we need to set up.
At organization A, We have SQL Server 2017 which is both the publisher and a distributor.
At organization B, on a remote server, we have a ...
- 175
2
votes
2
answers
214
views
SQL Server replication methodology
I have a relatively large production environment (150GB) in SQL Server, and I need to duplicate it somewhere else for querying (specifically: I need to create an environment identical to the ...
- 711
0
votes
1
answer
289
views
Transactional replication upgrade from SQL Server 2017
We would like to inplace upgrade of transactional replication topology from SQL Server 2017 to SQL2019 with minimal downtime. The following is the setup. All the all current instances are on SQL ...
- 113
2
votes
0
answers
198
views
CREATE or ALTER when using replication
I am using CREATE OR ALTER in the scripts for all of my views and stored procedures, as they are pushed frequently from a CD pipeline. I am also using replication to push certain tables, views, and ...
- 121
0
votes
0
answers
297
views
Transactional replication in sql server 2017 but job not running
I have created transactional replication and here is my script
Distribution script:
use master
exec sp_adddistributor @distributor = N'servername', @password = N''
GO
exec sp_adddistributiondb @...
1
vote
1
answer
123
views
SQL Server strategy for high availability with batch drop/create updates [closed]
Have a production SQL Server 2017 db that is populated nightly using sqoop from another source beyond our control. Would like to fully sync certain tables without bringing down the app (right now we ...
- 113
1
vote
0
answers
336
views
SQL Replication sysarticles Status 57
I am looking at the data kept in the various SQL Replication tables. I am trying to understand what information is available and what it means.
In this example I have push replication on the database ...
- 6,298
1
vote
1
answer
875
views
Selecting specific table for each subscriber when using merge replication in SQL Server with multiple subscribers
I am using merge replication with SQL Server 2017.
I have one publisher, and two subscribers (all in all 3 database servers).
I need to replicate different tables to each subscriber.
Is this ...
- 25
0
votes
1
answer
113
views
when is it necessary to create aliases in the SQL Configuration Manager?
I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager
I see there are aliases.
I was wonder why ...
- 16.6k
1
vote
1
answer
820
views
is there a way (clean or unclean) to eliminate a filestream data file on a production SQL Server database?
Is there a way (clean or unclean) to eliminate a filestream data file on a production database?
I forced a garbage collection on an empty filestream :
sp_filestream_force_garbage_collection @dbname =...
3
votes
1
answer
2k
views
SQL Server Replication - Unable to start agent job - Username or Password Incorrect
I have recently tried to setup replication. We are using the following topology:
Publisher Server -> Distributor Server -> Subscription Server
We currently have this setup using a different set of ...
- 191
1
vote
1
answer
162
views
Is it possible to set up Azure as a publisher for Pull Replication to an on-premise database?
I am trying to set up Pull Replication from an Azure database to an on-premise database. I have set up the on-premise database as the distributor but when I try to establish a subscription to the ...
- 67
1
vote
1
answer
3k
views
Two-step Replication between SQL 2008 and 2017
I am currently using transactional replication from several SQL 2008 publishers to a central 2014 subscriber/distributor. I need to replicate this data to a 2017 server, which would require a 2017 ...
3
votes
2
answers
2k
views
Replication feature in SQL Server 2017 on Linux
We have a running production using SQL-Server 2014 in production. It has replication running and partial subscribers in several data centers.
I had a request to evaluate SQL Server 2017 on Linux so it ...
- 344