Urgent : Problem getting when transfer database backup file on network storage device by FTP

  • I have transfer database backup file on network storage device by FTP.

    When i upload backup file on FTP it reduce size of backup file.

    why it happen?

    Bec when i see header information of uploaded file , it see INCOMPLETE, due to that database is not restored.

    why size is reduced by FTP upload?

    How can i resolve this issue?

    Have u tried upload database backup file on FTP and then try to restore it???

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • Is the FTP succeeding? Is the file transferred completely?

    Are you doing the FTP in binary mode?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • yes, file is transferd but some size is reduced...

    How can i come to know mode is binary or other?

    If it is binary or other..then what should to do?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • Depends on what FTP program you're using. See it's manual/help file for how to check what mode the transfer is in.

    I know the file is transfered, but that doesn't mean that the FTP succeeded. It is possible to it to drop connection part way through and leave a partial file. Check the transfer logs (if you app has any)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Paresh Prajapati (12/29/2008)


    I have transfer database backup file on network storage device by FTP.

    When i upload backup file on FTP it reduce size of backup file.

    why it happen?

    Bec when i see header information of uploaded file , it see INCOMPLETE, due to that database is not restored.

    why size is reduced by FTP upload?

    How can i resolve this issue?

    Have u tried upload database backup file on FTP and then try to restore it???

    It depends on the FTP program and the File system on the Server, like NTFS,

    FAT in windows. zip the backup file and upload, it will show the correct size

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • Dear Friend!

    Try to use a compression software like winrar or any

    it reduce the size of the file and also it will hide the file

    formate try it.

    I think this problem becouse file size and formate

    Regards,

    Yousaf Khan 🙂

  • krayknot (12/29/2008)


    Paresh Prajapati (12/29/2008)


    I have transfer database backup file on network storage device by FTP.

    When i upload backup file on FTP it reduce size of backup file.

    why it happen?

    Bec when i see header information of uploaded file , it see INCOMPLETE, due to that database is not restored.

    why size is reduced by FTP upload?

    How can i resolve this issue?

    Have u tried upload database backup file on FTP and then try to restore it???

    It depends on the FTP program and the File system on the Server, like NTFS,

    FAT in windows. zip the backup file and upload, it will show the correct size

    I got solution for that.

    actually it was transfer file using ascii mode, now i have change it to Binary, and it is working fine.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 7 posts - 1 through 6 (of 6 total)

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