Try using Bulk Copy Program (BCP)

Thank you Koen, Mascot and Stewart

A big Thank you to all for your comments and wish you all a very happy new year...

Thank you Willem for the good Article.

Thanks shashank for the article... it is good.

Thanks for the good question...

Thanks for sharing this info Kenneth...

Excellent Question Steve... Thanks...

A good question... Thank you.

GilaMonster (2/21/2012)

You can determine it before you try. Both the backup header (RESTORE HEADERONLY) and the msdb backup tables have a column called something like HasBulkLoggedData. If that is 1...

Thanks for the good question steve...

Thanks for the good question steve...

Interesting question... thanks...

A very very good question Craig... Thank you...

Good Question... Thank you...