0
votes
0answers
204 views

SQL Server 2005 Mirror table between databases on same server

I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running. My goal is to simply keep an exact copy of a table in another ...
0
votes
2answers
504 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 ...
1
vote
2answers
384 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
86 views

SQL 2005 Replicated Database Indexes

I have setup a SQL 2005 database replication (transactional) between two servers. I have noticed today that the non-clustered indexes do not seem to have gone across to the replicated database. I ...
1
vote
1answer
191 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
2
votes
4answers
213 views

Log shipping on select tables

I know I am most likely using incorrect terminology so please correct me if I use the wrong terms so I can search better. We have a very large database at a client's site and we would like to have up ...
0
votes
1answer
46 views

Most suitable 'replication' technique for SQL Server 2005

I have a SQL 2005 database that is currently 15GB in size. We do a lot of web / intranet based reporting from thsi system and we're seeing a performance hit as a result. I'd like to create a copy of ...
0
votes
1answer
57 views

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available ...
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
367 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 ...
0
votes
1answer
311 views

Creating indexes on tables filled from transactional replication - SQL 2005

I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB ...
0
votes
1answer
124 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 ...
0
votes
1answer
87 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
503 views

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online ...
0
votes
1answer
477 views

Filtering columns in SQL Server replication - how?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
0
votes
1answer
208 views

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing ...
0
votes
1answer
212 views

Schema changes with replication

What are the steps to make a schema change to a SQL Server 2005 database using transactional replication? I'm trying to add a database column. I thought if I removed the article for the table, made ...
1
vote
0answers
36 views

MSSQL server 2005 replication - article properties

When i replicate some db, my schemas, roles and user information (connected with that db) are not replicated. Moreover, if table in db is empty, replication don't create it on subscriber side. How to ...
6
votes
2answers
363 views

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. ...
2
votes
1answer
192 views

Simple SQL Server 2005 Replication - “D-1” server used for heavy queries/reports

We have two SQL 2005 machines. One is used for production data, and the other is used for running queries/reports. Every night, the production machine dumps (backups) it's database to disk, and the ...
3
votes
1answer
511 views

Alter Stored Procedure in SQL Replication

How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication? I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so ...
4
votes
2answers
406 views

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I ...
3
votes
1answer
1k views

Replication sync failing; Publisher out of Identity ranges

I have Merge Replication set up with a SQL 2005 Publisher/Distributor and roughly 100 SQL 2005 Express Subscribers. Everything was working fine for months and now all of a sudden everyone is getting ...
2
votes
1answer
215 views

SQL Merge Replication - Filter Sets

I have a "working" Replication Set in SQL 2005 that we use in house to our users at remote branches on SQL Express 2005. I want to apply a filter to our biggest Set to help minimize the bandwidth ...
1
vote
1answer
56 views

Filtering Replication Sets for Top 2

I have a Replication Set that we use in Merge Replication(SQL 2005). I am trying to figure out how to apply a Filter of Top 2 to a table. Also, is there a way to set up a Filter so that it trickles ...
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 ...
1
vote
1answer
303 views

When I need to create a schedule for Snapshot Agent for push transactional replication?

I am working with transactional database replication for push subscriber. My database structure will not be changed soon. Do I have to use "Schedule the Snapshot Agent"? What is the main reason to ...
3
votes
1answer
100 views

What replication options exist between SQL Server 2000 and 2005?

We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances. The business partner databases that we need to ...
0
votes
1answer
957 views

Sql Server 2005 Replication: How to setup subscription with a sql script?

When going through the replication setup wizard, I can choose Generate script at the end. The script works fine for the Publication setup, however, when I run the generated script for Subscription ...
0
votes
1answer
130 views

Weird TPS peaks on SQL 2005 replicated database

When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases - I'm seeing the TPS increase to 1000 and then immediately drop back down again - this happens every 5 ...
0
votes
3answers
586 views

SQL Merge Replication - Compress Snapshot

I have Merge Replication set up at our company with a central SQL 2005 as the Publisher/Distributor and the clients are all SQL 2005 Express. In our remote branches we are having difficulty with ...
2
votes
2answers
1k views

Schedule Recreate Snapshot and Reinitialize Subscriptions - SQL 2005

Monthly I have to generate a new snapshot for replication and reinitialize subscriptions in SQL 2005. I would really like to automate and schedule this, but I'm not having much luck discovering how. ...
2
votes
2answers
259 views

Should I avoid SQL Server Replication?

I have an app that is used by people in the US and in China and the database sits in the US. The people using it in China complain that the performance is poor, so I was thinking of using SQL Server ...
0
votes
4answers
300 views

sql server 2005 Replication

We have a sql server 2005 which contains 4 to 5 databases which are updated everyday externally, Currently we are backing up the Database and attaching to a different server and working on it in order ...
1
vote
1answer
601 views

SQL Server Sync Jobs Betwen Primary and Secondary Server

I am setting up a Standby Server for disaster recovery and high availability reasons. My product relies heavily on SQL Jobs, as such, these jobs need to exist (Disabled) on the Standby server. I have ...
0
votes
2answers
280 views

Installing Replication on SQL 2005 SP3

I think I screwed myself on the setup of SQL 2005. I installed Database Services, but forgot to install replication. I then installed SP3. Is it possible to install replication after sp3? Or do I ...
4
votes
4answers
260 views

Best way to replicate / mirror 100s of databases in SQL 2005

I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, ...
0
votes
2answers
133 views

Replicate ALL databases in SQL SERVER 2005

We have a SQL SERVER 2005 with 700 databases running. Our idea is to replicate all the databases on the server with the SQL SERVER Replication Services ...
0
votes
1answer
238 views

Sql 2005 Detach Log File w/ Replication

SQL 2005 I want to move a log file to a different location. However, the database is the publisher for replication. What is the easiest way to move the file without having to recreate the ...
0
votes
1answer
652 views

Speeding Up MSSQL Snapshot Replication to SQLExpress Replica

I have a well-connected remote site that I'm delivering snapshots to twice-daily of certain tables. Snapshot replication is the only method that I can use based on the schema limitations of the ...
0
votes
1answer
414 views

Safely Grant Access to SQL 2005 Replication Monitor to Create Snapshots

0 vote down star I have a database that I'm publishing to a remote site using Snapshot replication (only method that will work given the application and database schema). Because the replica ...
1
vote
1answer
639 views

SQL 2005 Replication error

I'm trying to change the maximum transaction retention period in our SQL2005 tranasaction replication environment from the default 72 hours to 120. Either through T-SQL or GUI I get the following ...