SQL 2005 Backup File format

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

  1. gulerayh

    gulerayh Guest

    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, Jun 18, 2010
    #1
    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
    #2
    1. Advertisements

  3. you can use dts(data output) to transfer the data from SQL to flat file.
     
    Ryan.Guan(管悦), Jul 14, 2010
    #3
    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.