I wish to set up replication between 2 databases both on the same sql server. I wish to do this so that if the live db fails there is a mirrored version immediately available. ( is Snapshot or Transactional replication best for this I have read up on both but not sure still)
However as the wizard progresses, i am immediately told that the server is not set up as a distributor.and i dont know how to do this.
the warning or error i get is "because sql server agent on databasename uses the system account, sql server replication between servers will fail. to use replication between servers, select another server to be the distributor for bss-sql" I am reluctant to use our file server which doubles up as our exchange box so what option do i have please?
Many Thanks
Bluegirl
However as the wizard progresses, i am immediately told that the server is not set up as a distributor.and i dont know how to do this.
the warning or error i get is "because sql server agent on databasename uses the system account, sql server replication between servers will fail. to use replication between servers, select another server to be the distributor for bss-sql" I am reluctant to use our file server which doubles up as our exchange box so what option do i have please?
Many Thanks
Bluegirl