Thank you Steve, I found the answer after searching for sometime 😛

bitbucket-25253 (7/14/2011)

---

Some thing seriously incorrect about this:

Correct answer: Standard, Enterprise .

Explanation: In SQL Server 2008 R2, database snapshots are only supported in Enterprise and Data...

winash (7/14/2011)

---

Information on how to configure articles to not replicate deletes - http://www.sqlservercentral.com/articles/Replication/3202/

Regarding deferred updates - as mentioned in the link these happen for updates to the primary key and...

mohammed moinudheen (7/14/2011)

---

winash (7/8/2011)

---

One way of doing this would be to modify the article properties to not replicate deletes.

But if you need this behaviour for only a short period...

winash (7/8/2011)

---

One way of doing this would be to modify the article properties to not replicate deletes.

But if you need this behaviour for only a short period of time...

Nice question Steve, Thank you.

Thanks for q 🙂

Thanks Perry, I am going to try this one. I also have your PDF document which you had shared with me before.

It's a good interview question Gail. 🙂

Thank you Suresh, this was a useful article, quite simple to follow with neat examples.

If you an output file in the job step it would give more details regarding the job status. If you don't have output file in job step, I would suggest...

Can you tell me if you read the link I shared. I am sure you didn't and I am not...

This link from Paul Randal should be enough to clear your doubts.

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

Thanks for the question, good one.

Jason,

Regarding this I found something in MSDN. Hope this helps.

"Reinitialization occurs for one of two reasons:

You explicitly mark a subscription for reinitialization.

You perform an action, such as a property change,...