aaroo,

Most suggestions are so far very helpful. 🙂

I'd like to share a different perspective from Paul Randal that we should focus on restore strategy first then come up with...

I'm using SSDT 2010 that "Data Conversion" task in Data Flow keeps changing all input columns to "Unicode text stream [DT_NTEXT]" datatype; therefore, the package fails to populate data in...

I'll request the database to be upgraded.

Thank you,

Khanh Pham