Hello,

i want to backup my mssql server 2005. is there any way to backup sql
database to txt, doc, xls etc.. format? not .bak file format.

thanks

"gulerayh" <gulerayh (AT) discussions (DOT) microsoft.com> wrote

Backup creates backup files. You can export data to other formats, but
that's not the same as a full db backup.

you can use dts(data output) to transfer the data from SQL to flat file.

"gulerayh" <gulerayh (AT) discussions (DOT) microsoft.com> 写入消息
news07447E4-A234-46D0-976A-D86C2EC4735E (AT) microsoft (DOT) com...