'I:\MSSQL\DATA\Cypress_APP_Data.MDF' is the path for the data file on "Server A" you have to specify WITH MOVE in your restore.

If you are using the Management Studio dialog, you have to...

Is the clustered index in the order the data is being inserted?

If it is not, your inserts will continuously fragment your index because they will need to put data in...

You are correct in that you lose the benefit if the SAN admin is carving three partitions out of a LUN that is using the same physical drive array.

Of course,...

Yes, there is a UNION ALL component that will merget together two identical data streams.

Unfortunately, this is just as likely to hurt performance as it is to help, but you...

Replication will synchronize two databases.

For a mobile device, I assume you are using the compact edition of SQL running on the mobile device and that it will not be continuously...

You could verify it is a permissions issue by logging into the server using the SQL Agent account and trying to run the package through BIDS.

If it is, a proxy...

Transactional replication does not just re-apply T-SQL statements, it inserts, updates, and deletes records based on activity on these records. Yes, it gets this information from the transaction log,...

I have been running that configuration for a year now.

Make sure Management Studio and Visual Studio 2005 are already installed before installing Visual Studio 2008. The installs all work...

No.

You could put a synchronous component after it - like a sort.

Be careful you don't create a memory issue.

The Pervasive OLEDB driver needs to be a 64 bit driver. Make sure it is and that the 64 bit driver is correctly installed. Also make sure your...

I would code the logic into the ETL Package (I am assuming SSIS). It is pretty easy to specify not to run if the current day of the month...

This is handled in SSIS through "Package Configurations". They can be configured through the SSIS menu in BIDS. Look them up in Books Online and post again if...

Earlier, you said there was no limit to the number of rows, not the number of columns.

With no limit to the number of columns, the only T-SQL solution will be...

There just really needs to be a limit to the number of columns. Pivot will probably not work for you, but this can be done relatively easy.

Here is what...

You have posted limited information, but there are a couple of things to try.

First, when you re-displayed the data, was it using the same connection, or a different connection? ...