In most cases it is the company that decides on the title they want to call their personnel.

DBAs should be architecting solutions on a constant basis imho.

I have also found...

Can you post the error messages?

Regular depends on your transaction volume.

Shrinkfile only works if the log file is empty. If you are not backing up the transaction log, then the file will not be...

Shrinkfile won't help unless you are getting regular tlog backups.

Verify with them that they are performing those tlog backups.

Good to hear.

Can you provide more detailed information with sample DML?

A better option is to drop the second log file on the source database before you backup the database.

A second log file is pretty pointless except in the case where...

Jack Corbett (7/23/2014)

Are you stalking me?...

Despite the oldness of this thread, you only have those options in 2008R2.

Just another driving force for the upgrade to 2012. 😉

That link I posted goes through the settings to change to make that happen. The default behavior is a snapshot of the entire publication.

Changes to those settings snaps only...

You can add a new article and get it sync'd without a full snapshot.

Here is an article on how to do it.

http://ansqldba.blogspot.com/2012/02/adding-new-article-to-existing.html

The key settings are

allow_anonymous

immediate_sync

Like Jack I would consider the merge statement. One caveat is to be careful around filtered indexes.

Here is more info on that bug http://sqlblog.com/blogs/paul_white/archive/2012/12/09/merge-bug-with-filtered-indexes.aspx.

+1

Given the Oracle options, I would prefer this Oracle as well.:-D

It occasionally works to change the output on your source. The safest means to ensure it is the proper type though is to use a derived column transform like...