“操作系统错误 1394” - 我该如何预防?

“操作系统错误 1394” - 我该如何预防?

我的 SQL Server 备份偶尔会随机失败,并出现错误消息Operating system error 1394

有谁知道为什么会发生此错误以及如何防止它?

谷歌搜索后我发现:http://msdn.microsoft.com/en-us/library/windows/desktop/ms681385%28v=vs.85%29.aspx

ERROR_NO_USER_SESSION_KEY
1394 (0x572)
There is no user session key for the specified logon session.

这很棒......但没有告诉我为什么会发生这种情况。

SQL 服务器备份到 Windows 2008 Server 上的远程 Windows 网络共享。我们运行 Active Directory。有 50 多个不同版本(2000、2005、2008、2008R2)的 SQL 服务器,运行在 Windows 2003、2008 和 2008R2 上(提醒自己:我确实需要标准化!)

再次运行备份不会重现错误。

完整错误消息(已删除)

Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'SQLSERVER'.
  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch.
  ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\BACKUPSERVER\backups\SQLSERVER\DATABASE_NAME\TRANSACTIONLOG_backup_20111118_104731.trnz'. Operating system error 1394(failed to retrieve text for this error. Reason: 15105).
BACKUP LOG is terminating abnormally.
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   at SqlBackup(Object , Object[] )
   at System.Management.Automation.DotNetAdapter.AuxiliaryMethodInvoke(Object target, Object[] arguments, MethodInformation methodInformation, Object[] originalArguments).InnerException.message

相关内容