What do you mean by suffer? Slow down because of load?

You transfer over log records, and that takes some overhead. Not much, very little, but there is some slight overhead...

Apart from what Jack has asked, we do that here. Articles are versioned and we have an "active version" and then all previous versions. A field signifies which is the...

Are you restoring to the same files? Creating this many files might take time.

Why so many files, out of curiosity? Seems like extreme overkill and an admin nightmare.

Management studio is part of the client tools. It is in the same setup for SQL Server.

You are welcome and glad you found the issue.

As a general rule, for production, be sure you have enough space for 2 backups of all databases. These should be on...

The deadlock manager just picks a connection and kills it. There's no "how", it does it.

You need the client to detect that there was no successful transaction and resubmit it....

The sheet name is the table name. A CREATE TABLE statement in an Execute SQL task creates a new sheet.

I'm not sure what you are asking here. Please be more clear with your English and ask a specific question.

It almost appears that you're wanting answers to questions someone has...

I haven't seen these either. Perhaps someone has BackupExec or some other third party product running. Check with other sys admins.

Do you mean execute the package twice? The variables don't maintain from execution to execution.

How often do you need to synchronize? Is it a 2 way sync?

The issue is that VFP uses flat files, the application actually has to use DLLs to read and...

Thanks, Josh. Good work.

You might want to submit this as a script using the "Contribute" link to the left.

Database size isn't relevant. It's # of transactions that have to be sent from one to the other that create the load.

The configuration manager is for managing services. Management Studio is used for creating databases, managing security, etc.

The application needs to trap the error and resubmit the transaction. The deadlock manager kills the connection, so you can't do this in T-SQL.