Markus (7/17/2012)

---

I always set max memory for our SQL Servers to leave 2 gig free for Windows and other things running on the server. You are just asking for...

Sean Lange (7/17/2012)

---

Well I have to say the new system is a horrible design. This is going to cause nothing but pain trying to parse them out later. If at...

You could logship the existing subscriber and set up the new subscription without synchronizing.

No need to initialise from backup.

I have a drive for Page file, a drive for tempdb, a drive for logs and a drive for data.

In my experience you are better off having your distributor close to your published database. Depending on the speed of your connections between all sites it doesn't need to...

Internal functions/methods/procs (?) only and you cannot invoke them manually.

You can trace many of the system procs in mssqlsystemresource and get to a dead end where these are called.

Not in this scenario. Are both servers replicating similar volumes of data/commands?

The real benefit of pull comes when you have a significant number of publications/subscribers. You can chose...

To replicate a 1.5TB database to a test environment? The table locking on the production server alone is enough to make me wince. ...

To replicate a 1.5TB database to a test environment? The table locking on the production server alone is enough to make me wince. ...

sqluser_8119 (7/10/2012)

---

I need to replicate a 1.5TB database to a testing environment. They want at least a weekly update from prod to test. What is the best way to do...

Stewart "Arturius" Campbell (7/10/2012)

---

Therein lies the issue.

There is a good chance that, with only clustered indexes, Clustered Index Scans are being performed on the table(s).

Seeks are much more efficient.

Is it...

A number of things could cause this.

1. SQL Version Number

2. Differences in data and data distribution in the required tables

3. Index differences

4. Schema differences

5. Database configuration options

6. Server configuration options

What...

So long as you are using push it is that simple. Pull you need to do a little clean up on the subscriber by running a repl proc.

You're better...

raymond.an 94329 (7/9/2012)

---

so when i try to another subscription , i shouldn't tell it to resnap shot straight away and wait for a quiter time to re-snap shot for the...

Transactional replication only causes blocking on the source server when generating a snapshot.

Have you got the snapshot agent scheduled through a job? You only ever need this...