Wait 5 minutes everyone... let Steve log...

This thread has become a monster. It has taken over everyone. I had not checked this thread in the last three days and now I have no way of following...

It is part of replication. It runs once a day at a scheduled time. It does not do anything with your performance. So I do not see why you would...

That is not a need to worry. As long as the log reader agent is running and once in while it shows something like "1 transaction(s) with 2 command" it...

Is peer to peer transactional replication available in SQL 2000?

Looks like the back up is no good. Did you Zip the file before transferring it from your collocation?

I have heard and read about an arbitrary limit for replication. Check this link.

On another note, you should have Log files should be on separate drive as well. The log files it is mostly sequential writes but data files are random.

Adding a new drive with its own IO controller for TempDB will help with IO bottlenecks. Keep in mind that TempDB is used heavily from 2005 to 2008.

Did you get an update in 2008 forums? If not, maybe you should look up Merge replication. There is also updatable transactional replication. Two way. That too might work. I...

By default, windows administrators are not sysadmins or not even members of Public role SQL Server. You will have to explicitly add a Windows authentication user. You could add just...

In SQL Server 2008, a system admin (Network administrator) is not a sysadmin on the SQL Server by default. If you do not add the group or user to SQL...

It will create the same table lock issues. It does a schema lock when creating the table scripts. Maybe you can look at initializing with back up. I have never...

If you initialize the data using snapshot, and if the snapshot agent created the tables in the subscribers, it should have created all the index for those tables. It is...

I Agree with Steve. You do not give DDL_Admin privileges to people who are irresponsible. You will need to remove these people from DDL_Admin role and then give explicit permission...