September 16, 2010 at 2:18 pm
Hi,
I have SQL Server in one of the co- location. I tried to copy the back up from this co-location to my work place server.
When I try to restore the back up copy, it gives me an error saying " didn't reach the end of file" error number 18210.
Any sort of help will be greatly appreciated.
Thanks
September 16, 2010 at 2:29 pm
Looks like the back up is no good. Did you Zip the file before transferring it from your collocation?
-Roy
September 16, 2010 at 3:14 pm
No I did not zipped the file. I just copied the *.bak file and tried to restore it. The size of the file is approx 80 Mb
September 16, 2010 at 11:30 pm
Do a RESTORE HEADERONLY on the backup file. It should tell you whether the backup set is complete. If you see "INCOMPLETE" in the output, the backup file is bad
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 17, 2010 at 2:33 am
Gaurav-934012 (9/16/2010)
Hi,I have SQL Server in one of the co- location. I tried to copy the back up from this co-location to my work place server.
When I try to restore the back up copy, it gives me an error saying " didn't reach the end of file" error number 18210.
Any sort of help will be greatly appreciated.
Thanks
hi Gaurave
I think the backup set may improper, pls check it by.
restore verifyonly from disk= 'Pathof_file\file.bak'
And let us know the ver. of SQL servers in both location.
Ali
MCTS SQL Server2k8
September 17, 2010 at 4:40 am
Hi Gaurav,
This may help you.
http://www.sqlservercentral.com/Forums/Topic182854-92-1.aspx#bm560099
Thanks,
Shailesh
September 17, 2010 at 7:46 am
Please follow the advice as Roy pointed out to zip the backup file while transfering and then try restoring the backup.
We had similar issue in out Stage server and was resolved by zipping the backup file and transfering it over network or FTP.
"More Green More Oxygen !! Plant a tree today"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply