Post reply

SQL Server 2005 Backup File Format

  • June 22, 2010 at 7:27 am

    #224121

    Hi All,

    i want to ask that, is there any way to backup or export sql server 2005 database to txt or xls file? i need that file format because i would like to transfer mssql 2005 database to mysql database.

    thanks for helps

  • June 22, 2010 at 7:46 am

    #1183335

    you can not run a 'backup' to excel but you certainly can export a table to excel. If you click on a database and select export data then you can go through the export wizard to export all tables at once.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 22, 2010 at 10:13 am

    #1183457

    do i have to backup database bak format? is there any way to bakup database different from bak format??

    thanks for reply.

  • June 22, 2010 at 10:16 am

    #1183461

    as far as I know bak is the only format that is native to SQL processes for the Backup process. There are several third party programs that do backups and they may use some additional format.

    from a native process however there is only a single format.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 22, 2010 at 12:00 pm

    #1183521

    thank you very much for your reply

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply