My gut feeling is that you can get this done by tweaking linked server only. I will try to re-produce this in my environment today.

Thanks

Chandan

Sorry about that. Did you turn on the data access true as well?

kingdonshel (9/21/2012)

---

After setting up Replication (Transactional Publication with updatable Subscription)

between two instances one instance being both Distributor and Publisher, with the other being a Subscriber running on my local...

Script out objects as Lynn suggested and use SSIS to import the data. Else you can also go for the replication option to minimize the downtime.

Thanks

Chandan

Satish-1028188 (9/18/2012)

---

Thanks Perry, your suggestions make sense, I would see now, How I can impliment this in my case.

Thanks Sudhakar, yes (in last few cases) it was in-between t-log...

I apologize for sounding so dumb 🙁

I read your links but still cannot figure out how can we decide the order of the columns. People who wrote the query might...

Thanks for the link. Being a regular follower of your posts, I had gone through the first link many times.

I may not...

Mirroring solution will work fine to minimize the downtime but please make sure that you have exact versions of sql server with exact level of service pack.

Thanks

Chandan

Vera-428803 (9/11/2012)

---

Hi all,

We are about to replace our infrastructure, inclusiding backup and tape library. For backup and recovery, we will use CommVault, an Enterprise backup and recovery software. Apparently, with...

lianvh (9/11/2012)

---

Good Day,

w had an auditing team running Microsoft Assessment on our database servers . This product recommends that the principle of creating ONE datafile per cpu be

deployed on...

I increased the mirroring time-out property and made it to 30 seconds. So it covered some network hiccups. Please...

1) The error could be due to early cleanup or purge of the log file before the restore could have processed. Increase the time duration for retaining the backups files

2)...

you mean to say primary key is not a requirement for transactional replication?? If yes, I...

GilaMonster (8/27/2012)

---

Technically it's not minimally logged. It doesn't behave as minimally logged operations do. It's fully logged, just as drop table is fully logged. Both of them log just the...

smallmoney (8/20/2012)

---

I truncated a table in my mirrored training environment on Principle side.

From what I remembered, TRUNCATE TABLE [tablename] is not a logged opereation.

Will this cause problems on the Mirror...