SQL 2005 Backup File format

[gulerayh]

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

[Paul Shapiro]

Post by gulerayh
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

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

[Ryan.Guan(管悦)]

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

Post by gulerayh
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