December 29, 2008 at 10:14 pm
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???
December 29, 2008 at 11:09 pm
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
December 29, 2008 at 11:37 pm
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?
December 29, 2008 at 11:51 pm
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
December 29, 2008 at 11:55 pm
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
December 30, 2008 at 12:31 am
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 🙂
December 30, 2008 at 5:24 am
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply