InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 03:36:51 GMT20http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHave to say we did have seemingly random errors on backups when backing up to a network drive. After lots of searching we put them down to network blips!Wed, 06 Mar 2013 07:53:47 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxI occasionally experience similar issues when backing up to a network share. When this occurs I'll run RESTORE HEADERONLY, RESTORE VERIFYONLY, then I'll restore it to another system and run DBCC CHECKDB. If it passes all three, I'm comfortable.[quote]Here is my question:How can the backup file is created when the backup command is terminated?[/quote]Here is one example (may or may not be your case) that may answer your question:[url]http://stujordan.wordpress.com/2012/06/14/sql-server-compressed-backups-fail-with-setendoffile-error/[/url]Wed, 06 Mar 2013 07:42:49 GMTHenry_Leehttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxIs there enough disk space space avaialble on your source drive?Wed, 06 Mar 2013 04:04:43 GMTSqlsavyhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxThis issue occurs every time we backup over the network during traffic timeTue, 05 Mar 2013 15:26:14 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHI Team,I have one question ,when you terminated the backup activity ,did you received any error in windows event viewer and sql server error log. Can please let me what is error you have received .Tue, 05 Mar 2013 07:51:56 GMTvivekinmadarhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHI Team,I have one question ,when you terminated the backup activity ,did you received any error in windows event viewer and sql server error log. Can please let me what is error you have received .Tue, 05 Mar 2013 03:57:59 GMTvivekinmadarhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxYes. SQL Server occasionally loses it's mind on such things. Over the last 16 years of using SQL Server, I've given up on trying to find the reasons. It appears to be because of spurious pips on the network when you have a waxing moon with the correct angular displacement to certain sunspots and the Red Wings are playing a home game on a rainy day but only during high tide and the coffee machine across the room is cycled. :-DMon, 04 Mar 2013 16:43:02 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxDo you guys have any theory of what happened?Mon, 04 Mar 2013 08:41:41 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxNo, I used standard script task to to issue the command 'backup database xxx to disk ='\\yyy\xxx.bak'Wed, 27 Feb 2013 15:02:28 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHello. Are you using the (Reliability) backup option "Verify backup integrity" checkboxduring the backup session in SSIS?Regards,Mark G.Wed, 27 Feb 2013 12:57:32 GMTganci.markhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxNo server/OS issue at all, and yes, account has permission to add/drop/modify file on that share folder. Weirdest thing ever.Wed, 27 Feb 2013 07:28:43 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxNo, i meant whether there are other errors like ntfs errors or Hardware errors in the Log.An important Thing would also to check the permissions of the service Account. Has the Service Account Full Access to this folder?Wed, 27 Feb 2013 01:13:58 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxYes I looked at the event log and confirm that the command failed. Server event log and SQL event log both confirmed that the backup command failed.Tue, 26 Feb 2013 20:10:09 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHave you looked for other errors in the Event Logs?Tue, 26 Feb 2013 14:31:08 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxyes, everything is good. I could not figure out why the file is there when the backup command is terminated.Tue, 26 Feb 2013 07:23:35 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHave you restored to a test server and ran CHECKDB on the restored database?Tue, 26 Feb 2013 04:59:40 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHave you tried to backup the Database on a local Drive? Is there the Same error?Has the SQL Service Account Full Control of this Share?Mon, 25 Feb 2013 23:40:57 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxI backed up the database on a share folder. The media is raid 5 disks.Mon, 25 Feb 2013 17:41:31 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxOn which Type of device you are backing up?Mon, 25 Feb 2013 17:35:39 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxIt is a native backup. I use SSIS script job to fire the backup command.Mon, 25 Feb 2013 15:46:05 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxIs this a native backup or are you using third party software to compress the backup?Mon, 25 Feb 2013 15:40:01 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxYes I have.I checked the file already using headeronly, filelistonly, and verifyonly. There is no issue with the file. The fact that i was able to restore that file on another server proving that the file is valid.Mon, 25 Feb 2013 15:33:35 GMTnamdinh4http://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHi,have you first checked the backup with restore headeronly?Occurs the error on every backup?Mon, 25 Feb 2013 15:09:49 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423768-357-1.aspxHey guys,I have an issue with backing up a 80GB database over the network, Here is the error:A nonrecoverable I/O error occurred on file "\\yyy\xxx.BAK" 64(The specified network name is no longer available.). BACKUP DATABASE is terminating abnormally. I know it is network related issue but the backup file (xxx.bak) is created on directory (\\yyy).I checked the backupset table on the server, that i backed up the database from, and verified that there is no entry related to (\\yyy\xxx.bak). I think it means that the database server does not recognize this backup file (xxx.bak) on directory (\\yyy)I was doubting the integrity of the backup file, so I verify the file by using Restore Verifyonly; the result comes back: the backup file is valid.I restored the backup file (xxx.bak) to a different database, and I was successfully restore that database to different server.Here is my question:How can the backup file is created when the backup command is terminated?Thanks in advanced.Mon, 25 Feb 2013 13:50:59 GMTnamdinh4