176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Setup MS SQL Server replication between two servers
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jun 4, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, May 29, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have two servers located in separate hosting centers. Connectivity is through the internet. The MS SQL Server databases are already created and operational. The distribution snapshot has been created for the publisher and is about 20 meg. is size.

The Primary Server is running Server 2008 with MS SQL Server 2005 and would be the publisher. The Backup Server is running Server 2008 with MS SQL Server 2008 Web edition and is to be the subscriber.

The need is to replicate a single database from the Primary to the Backup. There is no VPN setup. The project would be to establish the connection between the two databases and enable the backup SQL Server to be the subscriber of data. The connections must be sufficiently secured. There is no external hardware firewall, just the included Window's Server Firewall.

Access to each server would be through RDP.
------------------------------------------
Added 29 MAY 2012, 18:59 PM EDT
Update: Replication is transactional.

Sign in or Register to see more

Job ID: 30867781
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
INVITED
Microsoft SQL Server DBA since 1998 for numerous companies of varying sizes and industries with a solid track record for uptime and performance....
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30911141  |  Submitted: May 31, 2012 10:30 ET 
Proposal SEALED

 United States  |  
INVITED
I am a Microsoft Certified Database Administrator and MCITP (SQL Server 2008) with 15 Years of strong experience in scalable database design,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30889739  |  Submitted: May 30, 2012 14:01 ET 
Proposal SEALED

 United States  |  
Seasoned IT professional with experience in peformance tuning and optimization of SQL Server hosts, stored procedures, functions, and indexes. My...
4
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 30884706  |  Submitted: May 30, 2012 10:37 ET 
Proposal SEALED

 Canada  |  
INVITED
My core competency lies in SQL Server performance tuning/optimization, designing high availability solutions using...
2
  |  
 0.0   |  $1,251 Earnings   |  0 Jobs
Bid ID: 30882016  |  Submitted: May 30, 2012 08:39 ET 
Proposal SEALED

Ali Safder      
Ali Safder's identity has been verified.  Learn More
 Pakistan  |  
Expert in VB, C#, .NET, and Sql Server with database analysis and design. Skilled in developing business plans, requirements specifications, user...
4
  |  
 4.0   |  Private   |  1 Jobs
Bid ID: 30875690  |  Submitted: May 30, 2012 03:04 ET 
Proposal SEALED

 United States
INVITED
Build new database systems Backup and restore database system Set security on database, table, column... Maintainance :re-index, improve...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30868511  |  Submitted: May 29, 2012 19:36 ET 
Proposal SEALED

Abi Chapagai      
Abi Chapagai's identity has been verified.  Learn More
 United States  |  
INVITED
I have 10 plus years of experience in Information Technology field and have seven years of experience in Database Administration and Management...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30867897  |  Submitted: May 29, 2012 18:44 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »