“作業系統錯誤 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 Server 備份到 Windows 2008 Server 上的遠端 Windows 網路共用。我們運行活動目錄。有超過 50 個不同版本的 SQL Server(2000、2005、2008、2008R2),運行在 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

相關內容