0
votes
0answers
34 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
-1
votes
2answers
93 views

Secure communication between two hosted dedicated servers? [closed]

I'm planning to host a site on a pair of dedicated servers (both running IIS/SQL Server with SQL replication). Since the hoster only provides a public IP on each machine, how would I secure ...
1
vote
2answers
72 views

Switching SQL Server Replication Publication

I have a production database hosted on SQL Server 2008R2 Standard that is replicated to a second server running the same version of SQL server via a subscription to the production database. The ...
1
vote
1answer
117 views

Failover server for SQL Server mirror errors after reboot

I have two Windows Server 2008 servers set up, both running SQL Server 2008 R2. One is used as a primary DB, the other as a mirror failover (two website DBs + ASPState for sessions). Everything works ...
0
votes
0answers
59 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
1
vote
2answers
259 views

SQL 2005 replication not working

I am in the process of creating replication between 2 remote servers, server 1 is the distributor and publisher and server 2 is the subscription Server 1 windows 2003 server 192.168.10.1 connected ...
0
votes
1answer
886 views

SQL Server replication pending transactions

I'm having a problem with a transactional replication. I have the publisher in my server and there is a subscriber in another server. In my server, if I go to the details of the subscription I can ...
0
votes
1answer
195 views

Should I never put a transactional replication distributor on a subscriber server?

What factors into choosing a distribution server for transactional replication? In our topology, we've always had the distributor reside on the publishing server. We rarely generate snapshots and ...
-2
votes
2answers
166 views

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the ...
2
votes
1answer
250 views

SQL Server Broker Service with Active - Active replication in place

We currently have two datacenters in Active - Active mode and using SQL replication between the two datacenters (with a small delay). I'm developing a new process that will use SQL Server Broker ...
1
vote
3answers
99 views

How do I data warehouse a set of tables and delete the source?

I have a large table in MS SQL that I am having issues reading from while a third party application writes to it. My plan to resolve the problem is to move all of the data from one database and delete ...
1
vote
2answers
559 views

Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?

We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
2answers
626 views

How to move the files of a replicated database (SQL Server 2008 R2) to a different drive

I would appreciate if someone could help me with the following problem: We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
0
votes
1answer
222 views

SQL-Server 2008 : Table Insert and Range Check ?

I'm using the Table Value constructor to insert a bunch of rows at a time. However if i'm using sql replication, I run into a range check constraint on the publisher on my id column managed ...
2
votes
2answers
176 views

MSDE 2000 to MSSQL 2008 SQLExpress replication

I have an old database on MSDE which I need to replicate (one-time process) to a new MSSQL 2008 SQLExpress installation. What are my best options to replicate without involving messy sql scripting? ...
3
votes
2answers
831 views

Safe initial sync for SQL Server OLEDB/ODBC Replication

I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider. I can successfully create a subscription, and transactions ...
1
vote
1answer
245 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
1
vote
2answers
428 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
0
votes
1answer
532 views

Trouble to create new subscription

I am getting trouble to creating new subscription in the Local publication. I was able to create the Local publication at the Replication However, after I created sub subscription and I just ...
0
votes
3answers
675 views

Multiple Active Nodes with SQL Server 2008 R2

Is this possible either out of the box or using additional tools or frameworks? I'm looking to set up at least two simultaneously active machines to better understand how high scalability for ...
2
votes
3answers
204 views

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot ...
1
vote
1answer
118 views

Monitor SQL replication publishers from subscriber

I have transactional replication with many publishers(50+) and one central subscriber(data collecting). Is there some way(feature of SQL server, 3th party tool) how to monitor all publications from ...
0
votes
1answer
141 views

SQL Transaction Replication prevents procedure with distinct on varchar(max)

When I'm adding one procedure article to the Publication the I get this error: The text data type cannot be selected as DISTINCT because it is not comparable the proc is a simple select distinct ...
1
vote
0answers
145 views

Identity Range Management problem

Recently upgraded from SQL Server 2000 to 2008. When we recreated the Merge Replication we decided to use Automatic Identity Range Management (since it is now the default in 2008). The problem is ...
3
votes
3answers
2k views

How to: Hot Standby SQL Server in another datacenter?

For our SaaS app, I want to have a system in place for a datacenter wide failure. In the main datacentre, we have two servers set up with MSSQL Database Mirroring (synchronised). This provides us ...
1
vote
1answer
210 views

how to? Deploying a SQL 2008 backup to overwrite a database that has replication?

I am trying to figure out the proper procedure to overwrite a database with a backup of a database created on a different server. The backup has an identical schema, full text indexes, stored procs, ...
2
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
0
votes
2answers
86 views

SQL 2008. Help to pick right replication model

The database is end of day data storage with some reporting. We fill db with data for a particulate date every day. Time to time users' reports block import processes (run from C# apps and then ...
0
votes
2answers
140 views

I want SQL Compact to push its data to SQL Server

I would like the data in my SQL Compact database, located on a Windows CE device, to be periodically pushed to a SQL Server instance in a remote location. How would I do that? Do I need programming ...
0
votes
1answer
172 views

Will a SQL Server Replication Reinitialization overwrite data?

I have a customer's server which is giving me a "Snapshot not available" error when trying to do it's replication. From what I've read, I need to mark it for reinitialization. Now, here's the ...
1
vote
1answer
180 views

SQL 2008 R2 3rd Party Peer-to-Peer Replication, Global Site Distribution

We are looking at hosting 3 globally distributed SQL Server installations at different data centers. The intent is that Site A will serve web traffic and data for a specific region, same with Site B ...
0
votes
1answer
129 views

SQL Server 2008 Replication Promotion

I have a 4 node cluster, 1 subscriber and 3 publishers, all running SQL Server 2008 R2 Enterprise. The intention is that if the subscriber goes down, we can use one of the publishers to quickly build ...
0
votes
1answer
2k views

SQL Server 2008 - Performance impact of transactional replication?

I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription. Should there be a ...
1
vote
1answer
546 views

SQL Server - VMWare Install - Transactional Replication causing 100% CPU

I am having severe trouble with a SQL Server - in particular, with transactional replication. We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB” The server was ...
2
votes
2answers
914 views

Can I replicate data between mySQL and SQL Server/SQL Azure?

I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to ...
0
votes
1answer
191 views

Selective replication in sql server

I wanted to replicate my database across 2 servers both using sql server 2005. The problem is that the main server have both 'User' and 'Admin' data in a table. At the other end , I want to replicate ...
3
votes
1answer
1k views

One way replication from MSSQL2005 to MYSQL 5.x

I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server. I have successfully made the mysql server an ...
1
vote
1answer
405 views

Trouble with Identity Range Sizes

I am trying to setup our replication with a republisher. We, unfortunately, have some tables with an int PK IDENTITY and I am getting the following error when trying to create the publication. SQL ...
1
vote
4answers
3k views

Replicating/Synchronizng multiple tables across different Databases on the same instance

I have few tables that needed to be replicated/synchronized across several databases in our SQL Server 2008 cluster. I know it's possible to replicate between multiple instances, but I'm looking for ...
0
votes
1answer
1k views

Replication doesn't start after reinitializing in MS SQL 2008 R2

After subscription had been marked for reinitialize, a new snapshot was generated. Log reader and queue reader agents are running. But when we try to turn on the synchronizing, we're getting the ...
0
votes
1answer
163 views

SQL Server 2008 One-Way Mirroring

I'm new to DB admin but learning fast. We have a large SQL Server 2008 setup and I've just implemented a three-stage testing system - Alpha, Beta and Live servers. All three run the same version of ...
1
vote
1answer
150 views

Choosing the right SQL server replication type

This is the scenario: 1 x SQL Server 2000 database running at remote site (Publisher) Website running at a different site requires mostly read and some write access (<5 tables) to the database ...
1
vote
2answers
2k views

How do I get alerted when SQL Server 2008 replication fails for any reason?

We have managed to get SQL Server 2008 merge replication working. However, it will occasionally fail for inexplicable reasons (currently, it's because of MSSQL_REPL-2147201021.) When this happens, ...
0
votes
1answer
138 views

is it possible to lower the priority of the replication process in sql server 2005

we're planning on running transactional replication of a part of our database for some near-time reporting. I'm not quite sure which process will run to 'do' the replication, but is it possible to ...
1
vote
1answer
51 views

Backup or replicate one sql server to another

I have 2 instances of SQL server running on 2 separate servers; let's call them sql1 and sql2. How do I make sure that one database in sql1 is backed up to sql2 at least nightly? I know nothing ...
0
votes
4answers
1k views

Is database locked when it's in replication process?

I'm doing POC on database replication, and I'm stuck with question from my boss. Is database locked when it's in replication process on SQL Server 2005?
0
votes
1answer
88 views

Can I replicated 2 SQL Server database with foreign key in some tables?

Assume I've 15 databases, 1 is main database and another is database located at various site. I need to create replication between main database and another. My fellows have tested replication and ...
0
votes
2answers
90 views

No data coming from the perfmon statistic SQL Server: Replication Dist

I am trying to get the statistics from my 2008 sql server replication SQL Server: Replication Dist. statistics, but no data is coming even while replication is in full swing. I am using SQL 2008 ...
0
votes
1answer
58 views

Problem in SQL SERVER 2008 Replication

I Synchronized a database from one server to another server by using Replication... Server1 is Publisher and Server2 is Subscriber. I have created a table in that database in both the servers. when i ...
1
vote
3answers
830 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...