Replication Issue

[Rickspx]

Hi,

Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the
data grows it takes time when the snapshot is applied, so the webcontents goes blank for abt 2-3 mins.I had first tried
transactional , but as the keys(PK) were not getting replicated , snapshot was selected.Is there any solution for this?
Can I use transactional still have all my keys replicated by someway?Is there any other option?Plz Help

Thanks
Rick

 

[Rickspx]

Iam sorry abt that case described.Actually some tables used in replication does not have P. keys.So transactional cannot be an option.Iam looking for a work around for this

Thanks
Rick