Since you have your main Db with full recovery mode, set up a Warm Standby. So if your Main Db is gone, the warm standby can take over.

We have a new MVP in the forums now.... 🙂

You should take as look at sysobjects on your DB. You can use the parent_obj to get the name of table to which the index is connected

Hey Hey..I am not that bad... I was able to keep the drunken bunch of new year celebrators from...

You do not have primary key set up in the subscriber?

But you found out the problem.... 🙂 I had no idea why you should get it because transactional replication...

You cannot do all kinds of Alter table statements when the table...

I would not go for Replication in this case. It is too much of a hassle to deal with your particular scenario. I would say go for BCP or SSIS...

No problem Damon. Glad that it got sorted out.

Maybe I will go back to my singing...:D

Hey Fox, That was a low blow...:hehe:

Programmer / network Admin I guess.... I am not good for anything else. I am a lazy bugger..:hehe:

I have a drivers license. No Certification though. Dont have any books either. I have BOL, and the Internet at my finger tips at work.

Company gave me a lap top...

It is good practice to have different account for Distributor, publisher and subscriber. But if your Replicated DB is in the same network as your publisher, then you can use...

You have to create the Master key first before you create the Certificate. Try it out please and let me know.

Hi Damon,

When the encryption is done, the percent_completed should be 0 itself. Did you by any chance take the back up and try to restore it without license and with...