Transactional replication on database tables without keys.
Posted on 2005-04-28
I am required to make a backup server of a live database server.
Live & Backup are both running SQL Server 2000.
Backup should be completely in sync with live server so that at any time instant we can replace the live with the backup server.
For this purpose i choosed to implement transactional replication, but problem is that when i came to make publication of my database, it does'nt allow tables without keys to be published as articles.
Kindly tell me any way so that i can publish all tables either with or without key while using transactional replication.
Or if its not possible then tell any other way by which i would be able to make my backup server completely in sync with the live server.
Your early reply is required.
Thanx In Advance.