0
votes
0answers
54 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 ...
0
votes
1answer
61 views

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
4
votes
2answers
196 views

What's the cleanest way to reversibly break SQL Server replication?

I'm playing around with SQL Server Agent alerts, hoping that I can get some reliable error notifications sent out when our transactional replication breaks. To test it however, I need to break it. I ...
2
votes
1answer
847 views

What the best way to achieve RPO of zero and lowest possible RTO (less than 15 minutes) with SQL 2008 R2?

We are running a payments (EFT transaction processing) application which is processing high volumes of transactions 24/7 and are currently investigating a better way of doing DB replication to our ...
0
votes
2answers
168 views

Scaling web application with SQL Server 2008 database

I have a database which has 90% of read only tables. 10% of the tables has writable data. We need to scale the ASP.NET application.We need to add more users who will not be writing to the database. We ...
1
vote
1answer
151 views

SQL Server 2008 Snapshot Replication Trigger Start

I have setup a production server and a staging server. Whenever we are at the point in our release cycle where we want to begin testing on staging I want to copy the production DB over to our staging ...
0
votes
2answers
151 views

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is ...
0
votes
2answers
519 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
216 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 ...
0
votes
2answers
64 views

SQL server backups - backwards situation

Hi I'd like to know if it seems feasible to do things in this manner. We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is ...
2
votes
1answer
97 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
410 views

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 “R1”?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is ...
4
votes
1answer
157 views

What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services

Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day. These databases can range in size from 3 megabytes ...
2
votes
1answer
679 views

What are the advantages of async. database mirroring over transaction replication?

I've primarily a developer, but our organization is small, so I have been tasked with developing a HA strategy for our SQL servers. Currently, I manage our transactional replication to two additional ...
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 ...
0
votes
2answers
116 views

Synch SQL 2008 with failover server?

Currently they have a single SQL 2000 Std install on a server that needs to be retired. They run an app in terminal services to manipulate the data. So I'm looking at two new servers with SQL 2008 ...
1
vote
1answer
67 views

Setup SQL Server replication for schema only or schema + nightly data

We have 2 offices that we would look to keep our databases in sync with. Unfortunately one of our officers has a really poor connection and doing live SQL replication of the data probably isn't ...
0
votes
2answers
85 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 ...
1
vote
1answer
269 views

SQL Server 2008 Chaining Merge Replication

Is there a way to have multiple "tiers" for a merge replication in SQL Server 2008. For example I have SiteA with SQL Server 2008 that has a publication setup on TestDB. SiteB, also with SQL Server ...
1
vote
1answer
177 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 ...
1
vote
2answers
2k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
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 ...
0
votes
2answers
337 views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly ...
1
vote
1answer
533 views

SQL Server 2008 Replicating Linked Server Tables

I have a SQL2008 server with a linked Sybase server. I have several tables on the SQL2008 server that I need have merge replicated to some SQL2008 Express clients. I also need to get two tables from ...
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
155 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
0answers
41 views

SQL - progmatically change refresh rate for ALL publishers in replication monitor

How can I change progmattically change the refresh rate of all the publishers in the repliation monitor ? Without going into each one to change it's publisher setttings. MS SQL SMS 2008 R2 AHIA, ...
0
votes
1answer
1k views

How to reduce size of Distribution database used in MSSQL replication

Size of distribution database used in transactional replication has increased significantly, it is almost double of the database being replicated. Size of replicated database is 18 GB and distribution ...
2
votes
3answers
243 views

MSSQL Two Database Servers 1 Database

We have two servers. They are both HP DL 380 G6 servers with the same hardware and specs running Windows Server 2008. Currently the second server is a warm standby for the first with an automatic fail ...
1
vote
3answers
813 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 ...
1
vote
1answer
1k views

Table modifications while running db replication (MS SQL 2008)

I'm running SQL Server 2008 Std with a database that is being published in a "Transactional Publication" to a single subscriber. We are unable to make any changes to the tables on the publisher ...
1
vote
0answers
72 views

Which method of SQL Server 2005 or 2008 Replication is best for ease of field changes?

We need 15 minute warm updates from one SQL Server to another. Log Shipping looks good and appears easy to setup. We are also looking into Transactional Replication. The data only needs to copy one ...
0
votes
2answers
3k views

How to replicate windows server 2008?

We have 2 servers let's call them server A and server B. Server B is never used unless something goes wrong with server A. I need a system that can replicate server A to server B but this doesn't have ...
3
votes
3answers
534 views

What is the least expensive version of Microsoft SQL Server 2008 that supports replication?

We need to purchase two licenses for Microsoft SQL Server 2008 to upgrade Microsoft SQL Express 2008 so that we can mirror the two databases in two geographically dispersed locations. What is the ...
3
votes
1answer
2k views

SQL Server 2008 Replication & Sync Framework - Practical Limits

We are looking at hosting our client's data on our own system and using the MS Sync Framework to replicate data with a SQL Server instance on each client's site. Each client might have on average ...
2
votes
0answers
91 views

How to do Merge Replication?

I tried to do synchronization of database between servers to synchronize a database using merge replication. Simply I've added publication in server A and subscription in Server B by declaring ...
1
vote
2answers
2k views

In SQL Server 2005/2008 Merge Replication, what permissions are necessary for the Merge Agent account?

We're creating a Domain account to run our Merge Agent under, and we're trying to determine what NT permissions it requires. I can't seem to find a definitive list anywhere. Our replication ...
0
votes
1answer
3k views

Replication between SQL 2008 & SQL 2000 - Across network (DMZ) - process could not connect to Subscriber

I have 2 servers... OTTO is located on site, and connected to domain It is running SQL 2008. I have created the database, in SQL 2000 compatability mode. WEBDB3 is located in datacenter, not ...
0
votes
1answer
961 views

Removing Replication on SQL Server 2008

I have replication set up between 2 SQL Server 2008 servers, but I would like to reconfigure it again. Is it safe for me to remove replication during normal activity or should I wait until a low ...
1
vote
1answer
946 views

SQL Server Change Tracking between two Express servers?

Can I replicate my data (sql server 2008 express) using SQL Server Change Tracking to a read-only server?
0
votes
1answer
443 views

sql server 2008 snapshot agent problem

I've just installed mssql 2008 sp1 x64 on windows 7 RTM, and have the problem with creating snapshots, whenever I try to launch the snapshot agent (i.e. to setup transactional replication ...
0
votes
2answers
443 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...
0
votes
4answers
3k views

SQL 2008 Replication over Internet

We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. After evaluating number of replication options, apart from VPN there is no other way to ...
0
votes
1answer
891 views

SQL 2008 publisher -> SQL 2000 subscriber: Is a pull subscription possible for merge replication?

I am trying to synchronize a SQL 2000 SP4 subscriber to a SQL 2008 publisher via a merge pull subscription. When the subscriber tries to run the merge agent, it fails the following error: The ...
1
vote
1answer
366 views

Make SQL replicate over separate VLAN

I have two SQL Server 2008 machines, SQL1 and SQL2, doing replication between each other. Their main interfaces are on VLAN1 (10.1.1.0/24) and that's where clients reach them. For performance, I ...
2
votes
6answers
4k views

How best to script selected tables and data on SQL Server 2008?

The SQL Server Management Studio has the ability generate scripts. The problem is that it breaks on identity columns. I can't find a link to this bug at the moment but Microsoft basically declared it ...