Post reply

restore database

  • January 30, 2007 at 2:50 am

    #62120

    Hi

    how to restore database from the file type 'filename.bak.gz'

    when i tried to restore the database from the 'filename.bak.gz'

    the errior is

    'error: 3242 the file on device 'C:\Documents and Settings\sd\'filename.bak.gz' is not a vaild microsoft type backup set restore filelistonly is terminating abnormally'

    please give me your suggestions

  • January 30, 2007 at 2:54 am

    #686379

    Dear Sanjay,

    .gz is a zip format and thus will not be recognised by SQL Server. You will have to first unzip the file using gzip or gunzip utilities and get the .bak file out of it.

    Then you can restore your database from .bak file.

    HTH

    RSingh

  • January 30, 2007 at 3:15 am

    #686382

    please gime software link to down load this software. i tried with alpha zip software but it is not extracting

     

     

  • January 30, 2007 at 3:18 am

    #686385

     successfully database has been restored.   I downloaded the software

     

    Thanks for your nice suggestions.

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

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