Due To Os Error 64
Contents |
replication agent progess bar 12 Comments Synchronizing subscriptions in SQL Server Express 8 Comments Executing scripts with sp_addscriptexec 9 Comments Arithmetic Overflow in sp_MSarticle_validation No Comments Creating merge replication conflict due to os error 3 alerts 1 Comment Extending the Publisher to the Cloud 2 Comments How due to os error 5 to let non-admin business users run replication agent jobs 2 Comments Undocumented Gotcha in Merge Replication Tracking 2 Comments
Operating System Error 64
Single Brandon Williams Nov 30, 2011 5 Comments Merge, Replication, Snapshot, SQL Server, SQLServerPedia Syndication, Transactional, Troubleshoot error, troubleshoot The process could not read file due to OS error 3 When
Operating System Error 64 The Specified Network Name
configuring a subscription to a publication in SQL Server, sometimes the agent process cannot read from the snapshot: The process could not read file X:\Program Files\Microsoft SQL Server\
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 - General » Backup to device, UNC
The Process Could Not Read File Due To Os Error 5
file, generates OS... 14 posts,Page 1 of 212»» Backup to device, UNC file, generates OS the process could not read file due to os error 1326 error Rate Topic Display Mode Topic Options Author Message AlocyteAlocyte Posted Tuesday, August 11, 2009 2:18 AM SSC Rookie Group: General Forum Members mssql_repl20143 Last Login: Friday, November 16, 2012 4:39 AM Points: 31, Visits: 104 Hi friends, family and fellow SQL dba'sI have a bit of a bother, and it's OS / SQL related. I backup to a UNC device, and http://www.sqlrepl.com/sql-server/the-process-could-not-read-file-due-to-os-error-3/ frequently get a network related error - but not always. And the error is also OS related...The scene: 64 bit Windows Server 2008 hosts 64 bit SQL 2008 Standard, and devices are created to point to 64 Server 2008 Server B (\\ServerB\SQL_backups\dvc_DB.bak). The database is backed up daily, on a job, and when run the following error is returned:Date 2009/08/08 06:43:30 AMLog Job History (Backup_AssetData_2009-08-08)Step ID 3Server SQL01Job Name Backup_AssetData_2009-08-08Step Name Backup Database - Second http://www.sqlservercentral.com/Forums/Topic768429-391-1.aspx AttemptDuration 00:05:33Sql Severity 16Sql Message ID 3013Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: COMPANY\SERVICE_USER. Processed 94096 pages for database 'AssetData', file 'AssetData' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AssetData', file 'AssetData_log' on file 1. [SQLSTATE 01000] (Message 4035) The operating system returned the error '64(failed to retrieve text for this error. Reason: 15105)' while attempting 'FlushFileBuffers' on 'dvc_AssetData(\\riscsrv-dcm04\RISCSRV-SQL01_Backups\dvc_AssetData.bak)'. [SQLSTATE 42000] (Error 3634) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.The file is generated, the same size as a successful backup, but the job terminates unsuccessful.I have tried to delete the devices' file, and then the backup usually succeeds. This may point to a permissions' type error, but the user the job is run under is a domain admin. The destination server is not unavailable during this time, and the network shares also remain active throughout the excersize - although I haven't got a way to "prove" this.I am hoping someone can help me identify the cause of the problem, or has experience with a similar problem which has been resolved.I have a few databases that backup to the UNC described above (different files) that don't fail... some bigger, some smaller.My SQL2000 server backs up it's databases to the SQL2008 server, and those backups don't fail with this error. My res