kwoznica (5/18/2011)

---

Thanks for the response.

If a primary key exists but is not the identity field does that matter?

is the snapshot only created once, during the initial stages of the...

Perry Whittle (5/18/2011)

---

IIRC Windows 2008 can but SQL Server as an application cannot, worth...

I dont get it. You CAN publish a table and filter vertically.

i.e. decide which columns to replicate along with the PK.

Are you able to explain further as...

As this is centrally updated you would want to go with either transactional or snapshot. You can eliminate snapshot if the data is need 100% of the time or...

There are always pros and cons. In this case there is a management and set up overhead as...

happycat59 (5/16/2011)

---

You have missed a step - you need to add a subscription to the new article. Once that is done, the distribution agent becomes aware that it needs...

and that was my...

Roy Ernest (5/13/2011)

---

Pankaj Shere (5/12/2011)

---

This can be done. You need to modify the delete procedure used by replication to delete if older than 6 months. The procedure can be found...

Strictly speaking no.

Syed Jahanzaib Bin hassan (5/13/2011)

---

Microsoft support Active/Active Cluster but what does it mean active/active,its for multiple instance on a cluster and there is no any type of...

100% yes. TSQL is the only way to go.

logshipping

http://msdn.microsoft.com/en-us/library/ms188708.aspx

replication

http://msdn.microsoft.com/en-us/library/ms147855.aspx

mirroring

http://msdn.microsoft.com/en-us/library/bb510479.aspx

Pankaj Shere (5/12/2011)

---

This can be done. You need to modify the delete procedure used by replication to delete if older than 6 months. The procedure can be found on the...

You can set up a subscription with no snapshot requirement.

When you script the subscription, change this

@sync_type = N'automatic'

to this

@sync_type = N'none'

and run this on the publication database to generate...

IMO the most efficient method (least down time but more work) would be to setup logshipping of the dbs to the new server.

Followed by:

Create the logins on the...

You cannot keep more data at the subscriber. All deletes on the publisher would be replicated.

You "could" do this with replication to a degree. It would involve preventing...

I've seen doubletake software used in the past