SQL 2005 Backup File format

Discussion in 'microsoft.public.sqlserver.dts' started by gulerayh, Jun 18, 2010.

  1. gulerayh

    gulerayh Guest


    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.

    gulerayh, Jun 18, 2010
    1. Advertisements

  2. gulerayh

    Paul Shapiro Guest

    Backup creates backup files. You can export data to other formats, but
    that's not the same as a full db backup.
    Paul Shapiro, Jun 18, 2010
    1. Advertisements

  3. you can use dts(data output) to transfer the data from SQL to flat file.
    Ryan.Guan(管悦), Jul 14, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.