Make sure you are using  SQL EE to address all the RAM.

If you can separate OS & SQL install on one RAID 1 set, SQL data RAID10, SQL Logs...

I usually set it to 64K, unless advised differently from hardware vendor.

How big is your distribution database and how much of that space in it using before and after the cleanup? It maybe just a case that it has to cleanup...

I remember something from an old 6.5 internals course that covered sometimng like this - although I may hav ekilled those brain cells. What is does is that is logically...

I am assuming that the database that was backed up (MT2) was being replicated (what type of replication?) and that the SQL Server is what running on was the publisher...

Do the shrinkfile as another step in your job after the full backup and the tran log backup.

The above should work - stop the eval edition services, copy the .mdf & .ldf files to a different location. Do the new install, stop the SQL Services, copy the...

If you are trying to move a DTS package, edit the package and just save it to the new server.

In the registration properties for a SQL Server you can disable the displaying of the system databases and objects - this is done via the proc sp_MSdbuseraccess, you can look...

SQL Developers Edition should install on this platform.

Quickest method may be to drop the publication and recreate it.

I am guessing that the table names change each day and are dropped when the next days tables are created. You could create a publication dynamically every day to publish...

Are you sure that you have foreign keys defined?

If so as a work around script them and run them in manually on the subscriber.

Can changes occur simulatenously on Server 1 and Server 2. Or is this a situation where Server 1 is finished for the day and Server 2 takes over and when Server...

Have had similair issues with an unreliable DC. Problems may be caused with NT Authentication and the domain controller being screwed. Best bet would be to drop all NT logins...