Discussion:
SQL 2005 Backup File format
(too old to reply)
gulerayh
2010-06-18 08:48:14 UTC
Permalink
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
2010-06-18 11:12:31 UTC
Permalink
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(管悦)
2010-07-14 14:26:07 UTC
Permalink
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
Loading...