I would like to know, would it be possible to set up diffrent index 'INDEX1' on Table A in source and 'INDEX2' on Table A at the destination db using log shipping.
I am new in this. so if there is a way please explain bit more.
Also i tried transact raplication for that it seems to work but can anyone tell me what would be the effect on destination table if i have 3 column clustered index.
current database size is growing almost a Gig/month and one of the table has almost 12 milion lines which grows about 2 millions a month. so we r currently looking for a way to create a reporting server and production server.