It's more useful to understand how SQL stored replication information. This is what I would use.

select *

from syssubscriptions ss with(nolock)

inner join sysarticles sa with(nolock) on sa.artid = ss.artid

inner join...

Do the restored databases have to be read write?

What about customer sensitive data? Do you need to remove details which could identify customers? Card numbers?

Lynn Pettis (2/22/2012)

---

Jeremy... (2/22/2012)

---

MysteryJimbo (2/22/2012)

---

I dont mean to be pedantic but for accuracy I'd want to see this query as a between and in a stored procedure with default values...

I dont mean to be pedantic but for accuracy I'd want to see this query as a between and in a stored procedure with default values so it can be...

Im also a little confused. Does the table have a primary key or unique column that we cannot see?

Are you trying to iteratively move down the "list" and if...

If there are concerns over concurrency and there's no reason transactionally to update the rows as a single batch I would look at writing a simple loop to update the...

Sapen (2/21/2012)

---

Thanks for the reply Calvo. In this scenario how should I configure my shared storage. I meant can I use a single storage for both the instances? what...

rajiv.varma (2/21/2012)

---

Create a variable of string type and set its value as the following:

(DT_STR, 4, 1252)DATEPART("yyyy", @[System::ContainerStartTime]) +

RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mm", @[System::ContainerStartTime]), 2) +

RIGHT("0" + (DT_STR, 2,...

I'm not going to be able to do this for you. I can point you in the right direction of information where you can help yourself.

This article covers a...

Is there the possiblity of multiple files? If so you can use a for each loop container which will automatically populate a variable with its current filename.

If its a...

My general list consists primarily of logshipping the big databases, creating logins (with server roles assigned), linked servers and jobs in advance of migration.

Method 2 should still apply.

http://support.microsoft.com/kb/246133

I'm not 100% I understand this.

NirvanASQL (2/10/2012)

---

Now when i replicate EMP and EMP_HS both at subscriber, it works fine but if i replicate only Master table it does not...

and trigger

Package configs a bit too finicky for my liking and distribute the information into another location. ...