I tried to create a local snapshot replication from data A to database B for sql 2005. I followed the wizard and it was created successfully. But,nothing written to the replication folder and the job failed. I manually executed the sqls and it always failed on sp_addpublication_snapshot and th...more >>

Hello Everyone, I need to know all about SQL server 2005 Database Mirroring. For your information,I want to have a server backup,that if my original server is hanged then another backup server start to work. Thanks, Nassa ...more >>

I would like to build my warehouse with replicated data...I would like to report the last time a particular location merged. What is the best way to programatically determine the last time a location replicated successfully? I'm sure there are tables that contain the agents and their statuse...more >>

In a Sql Srvr 2k system a domain account is used to start both sql server and sql server agent. This domain account is currently defined in the local machine Local Administrators Group. I need to delete this account from the Local Administrator's Group. ( See support.microsoft.com/kb/283811 )....more >>

Hello, We are planning to use log shipping as replication method for standby database. My understanding that I have to make full database backup, restore it on standby server (with NORECOVERY option) and then can just copy transaction logs to standby server and apply them there periodically...more >>

We have a SQL Server 2005 Merge Replication to an SQL Server 2005 EXPRESS EDITION. After indefinable time intervals the error message: "They must again implement the Snapshot, since the current Snapshotfiles became outdated" comes. Can someone say something to me about the error message?...more >>

I am attemption to update a record in a SQL 2005 table that is trans. replicated with updates and I am receiving the following message.... Msg 208, Level 16, State 1, Procedure sp_MSsendtosqlqueue, Line 40 Invalid object name 'dbo.MSreplication_queue'. Any ideas??? AHIA, Larry.... ...more >>

We are starting to look into a high availability solution to ensure operation of our business in the event of a localized disaster (i.e.. building fire). We are planning on a remote site, maybe 25 miles away, that will provide virtual servers and resources via VMWare. We will need, among other t...more >>

I have a SQL 2000 enterprise database that is roughly 400GB. I am trying = to setup transactional replication. During the publication and = initialization of the database the tempdb on the SQL server publishing = the database grows very large and I run out of disk space. I let it grow = to 70GB ...more >>

Hi Guys, I have two questions regarding replication: 1, If I don't continue to use replication at all, how can I drop replication completely? Because too many command, e.g. sp_removedbreplication or sp_dropplication and so on. Which one can I use? 2. If I want to retore the replication datab...more >>

Hi, I wonder where can I set the UPLOAD ONLY parameter in the following codes in CE (VB.Net CF), or where I should change the settings in the SQL server? Try Dim repl As New SqlCeReplication() repl.InternetUrl = "http://developer/snapshot/sqlcesa30.dll" ...more >>

Hello, I have a publication that is pushed from a SQL 2005 Standard box to about 40 SQL express subscribers. One of the servers went down and was rebuild and I reran the same install script as I ran on the other servers ( I made the script). I pushed out the same subscription as before to it,...more >>

Is there anyway to clear replication monitor from subscriptions with error status? Tomek ...more >>

Hi. I've looked all over MSDN, newsgroups and the web but I can't find the answer to a problem that I am having. The application that I am working on used both transactional and merge replication. I want to avoid hard coding passwords into an application that kicks off the pull replication on ...more >>

Hi, I am managing an instance of SQL server which is running replication, I am not sure what SP is running on this version as I am getting conflicting information when I run "Print @@Version", the following is the result: "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:...more >>

We have SQL 2000 Merge replication with 2 publications...one with tables and the other with views and sp. The Snapshot Agent for the tables publication is bad (shows red X and status = Failed). If I try to start the agent it gives me Error 14262 indicating the @job_id ('....') does not exist...more >>

What will be better approach (pull replication or DTS package) in following case? Case: Sql Server 2005 database (1) will have data created by small application (all data will go only to one table), This data has to be used by legacy application that uses Sql Server 2000 (2) database. Tr...more >>

I have a following problem. Table T is replicating from Publisher to Subscriber. Both servers are Microsoft SQL Server 2005 - 9.00.2047.00. On table T there is a trigger (update/insert) on Subscriber that does updates on another table - O. Table O is replicated back to Publisher. Trigger is...more >>

Hi all, Cant seem to find a list of steps to configure the replication of a 2000 to 2005 Xpress pair running in the same 2003 server box. I am used to (few years ago!) replication setup between 2000 servers so I have In Enterpise manger 1. Created the Publication In Xpress management st...more >>

Hi, We have a huge problem at the moment with merge replication deleting data in our tables. Im running MS SQL 2000 SP4 and have several subscribers syncing their data back to the publisher on a daily basis. For some reason records are getting deleted out of 2 tables which have a parent chi...more >>

I have setup transactional replication evertything on one box. but Publications couldn't show up under computer name from replication monitor (you can see a red X on that computer name). I try many different ways, but it still doesn't work. any one know how to fix it !!! ...more >>

All, I use stored procedures from C#.net to configure and remove replication. Whenever, i remove replication i try to first check if any process for distribution DB (using sp_who2) is remaining in the SQL process space and kill it. The possible processes, i knew of using the distribution D...more >>