That did it, thanks to all!

Good thinking, I'll give it a shot.

Thanks!

There are about 500,000 rows in the table. The archive database is an exact replica of the production database. So yes, the table is indexed. The table is on a...

How about xcopy /d? Sounds like a possible winner!

Not really what we're looking for. We are not doing the log shipping process. Would have worked, but decided against.  Instead they are placing the logs in an available share for...

I've come up with this query so far and it tells me some differences, but not the percentage. I read that I just have to devide the number to rows...

The connection is up and fine? We are currently backing up to a local drive but wish to backup to another server for a failover situation. Any more suggestions.

I've got it figured out, but thanks for the reply. I simply imported the data into a separate table and then used tsql update clause to update the new columns....

How do I go about that? I can get the data into a separate table.

That is exactly what I'm doing now...but I was just trying to understand why I was receiveing the error doing it the other way? Who Knows?

Nevermind, I think I've got it figured out!

I tried copying the objects and the data but received this error: [microsoft][ODBC SQL Server Driver][SQL Server] The login 'Datawarehouse does not exist.

While doing this process I noticed that...