OT: SQL Replication

2004-06-02 Thread Eric Creese
Had a server in which a few drives died. Had backups of everything except the distribution database. I do not even have a backup of the data dile for it too. The distribution database is marked suspect. I can not drop the 2 Publications or the Distribution database since SQL is telling me it is

Re: OT: SQL Replication

2001-02-24 Thread Brian Panulla
Jim, Do both sites run ColdFusion? One possibility that I've been kicking around is using CF's WDDX to exchange data between servers via CFHTTP calls I think this model would work: 1) "Extranet" server receives new listing from local LAN users. 2) Listing is inserted into local LAN

Re: OT: SQL Replication

2001-02-24 Thread Dick Applebaum
Brian/Jim This approach *does* work. And, you don't need CF at the remote (web) site... it can be any system/language which supports WDDX. ASP/VBS, for example. I have implemented a similar approach when migrating a site from one App server/SQL Server Combo to a different App server/SQL

OT: SQL Replication

2001-02-23 Thread Jim McAtee
I've got the following situation: A real-estate company wants us to develop a suite of browser based applications for managing listings, client contact management, billing, etc. These applications would be used primarily in-house, but could be accessed by employees working from their homes or

Re: OT: SQL Replication

2001-02-23 Thread Dick Applebaum
Jim My tendency would be to recommend making the database (or some portion of it) web-centric. That is, a single copy updated from the LAN/extranet or the Web. Trying to maintain concurrent copies of data is near impossible under the best of conditions. If the copies are get of synch...

Re: OT: SQL Replication

2001-02-23 Thread Jim McAtee
MAIL PROTECTED] Sent: Friday, February 23, 2001 9:46 PM Subject: Re: OT: SQL Replication Jim My tendency would be to recommend making the database (or some portion of it) web-centric. That is, a single copy updated from the LAN/extranet or the Web. Trying to maintain concurrent copies of dat

Re: OT: SQL Replication

2001-02-23 Thread Jeffry Houser
At 09:10 PM 02/23/2001 -0700, you wrote: I've got the following situation: A real-estate company wants us to develop a suite of browser based applications for managing listings, client contact management, billing, etc. These applications would be used primarily in-house, but could be accessed by

Re: OT: SQL Replication

2001-02-23 Thread Dick Applebaum
another db altogether. Therefore, there's minimal two-way updating of the database. Jim - Original Message - From: "Dick Applebaum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 9:46 PM Subject: Re: OT: SQL Replication Jim My tendenc