RE: DTS causes TMPDB to expand on host Server

From: LS (LS_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 06:01:05 -0800

I am setting up a test SQL server for our programmers to use, as opposed to
the production server. They do not need all of the databases on the
production server on the test server, but there does need to be some type of
replication of the databases used. I hope this explains what I am attempting
to do?

Many Thanks,

Larry S

"Paul Ibison" wrote:

> It might be useful what is the requirement for
> your 'clone'. The reason I ask is that replication might
> not be the correct solution for your needs. On
> www.ReplicationAnswers.Com in the articles section I have
> put an article which details the differences between
> replication and log shipping for the purposes of
> maintaining a standby server. My suspicion is that log
> shipping may be more relevant for you. If not, then I'll
> help you set up replication once you've posted back.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>