Great article! I hope this is read and advice taken by those who expect someone to hand them the answer on a silver platter.

Did you install msde with SP3A on the new server? If so, did you set DISABLENETWORKPROTOCOLS=0?

If you did not set it to 0 (for sp3a) it defaults to 1 then the...

What about setting up transaction replication using server1 as the publisher/distributor and server2 as the client? You could schedule this to run nightly or whatever schedule you need.

To use a horizontal filter you can do it two ways. If you set up the publication via scripts use the stored proc sp_addmergearticle and use the @subset_filterclause like this:...

Yes, set up a filter statement to reflect what you want to replicate where. The merge pull agent will then retrieve only data reflected in the filter.

You can find a good bit of information re. push and push subscriptions in Books on Line. It is pretty clear there.

I am not sure if I totally understand your question. If the question is can you filter rows of data from a specific table to a specific subscriber, then the...

There are a couple of properties in SQL Server Agent you can modify to keep more history. If you right click on SQL Server Agent, choose properties .... choose Job...

thanks stacenic .. this is just what I am looking for .. now, I know there is a way to start the SQL Server Agent from a command line, but...

What do you mean by the password resets itself? Does it revert to a blank password?

There is a script on this site that should do the trick. Check out the script titled "Delete old backup files".

Are you sure you really want to shrink the database? If you shrink the database then add quite a bit more data later, then SQL Server will need to expand...

You can script the stored procedures. However, you will need to add permissions again. Use the GRANT EXECUTE ON ... statement.

When you right click on the subscription and choose "Error Details" does it show you the enough info about the row in error? It has been a while since I...

Create a Linked Server on one server and refer to it in your query. See BOL for more info.