Apparently, it's not really that the other server allowed the character and the test server did not allow it. The problem was during the export (BCP out). The...

Hmmm... okay, now I'm starting to understand it.

If you have two tables and wish to slide data from one table to the archive table, it doesn't really need that...

Yes, they are the same collation.

Source Server Collation: SQL_Latin1_General_CP1_CI_AS

Source DB Collation : SQL_Latin1_General_CP1_CI_AS

Target Server Collation: SQL_Latin1_General_CP1_CI_AS

Target DB Collation : SQL_Latin1_General_CP1_CI_AS

Sample Data that exists on the XML column...

Perry, you are absolutely right in your assumptions.

All i did was really write TSQL scripts that mimics the actions of the log-shipping. None of the scripts used was...

Hmmm... I tried it several times, but it looks like the problem was with my -n parameters. I used it because there is a column that is an XML...

Ugh! I was afraid I see that answer coming my way.

Thanks for confirming that Gail. I really appreciate it!

I've found the answer from this site and even better. The script to find the "Table Disk Space Usage By Filegroup and Partition".

http://williamweber.net/?p=21

Have you tried to put DISTINCT as part of your initial SELECT?

That way you solve the part of when you comment out the line for

--u.uid = user_id() AND...

As a result the log gets tremendously large.and because of that the restore job fails.

1.Can we decrease the duration of the log backup so that there will be more trn...

Ayayay!

I guess I am in the wrong belief that fiber-channel attached are always faster than other disk subsystems (except SSD).

I guess, i was just really surprised....

I am curious to the replies to this topic as I am in the same boat myself. I do share the same opinion though that Data availability and Application...

So, is SQL Azure more of a service given by Microsoft? Is it possible to have an Enterprise Private Cloud and maintain the SQL Azure within the Private cloud?...

Thank you so much Paul. It helps a lot when someone (especially of your caliber) confirms that this is the right path.

dg81328, thank you very much for pointing...

Hi Paul,

No offense taken, any comment is really welcome.

For the row count alone, there's probably other tables in the database that has more rows than this particular table...

I'm testing out the duration as well now for the bcp out, truncate and bcp in.

With the drop constraint with Move to another partition is just taking forever as...