Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get occasional and random failures of my SQL Server backups with the error message Operating system error 1394

Does anyone know why this error occurs and how I can prevent it?

A little Googling tells me:

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

Which is great... but does not tell me WHY this happens.

The SQL server backs up to a remote Windows network share on an Windows 2008 Server. We run Active Directory. There is a whole fleet of 50+ SQL Servers of different versions (2000,2005,2008,2008R2), running on Windows 2003, 2008 and 2008R2 (Note to self: I really need to standardise!)

Running the backup again does not reproduce the error.

Full error message (redacted)

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
share|improve this question
Something similar has been "discussed" at SQLServerCentral's forum a while ago. Not much of a resolution there, but at least you are not the only one with this problem. – the-wabbit Nov 19 '11 at 23:15
@syneticon-dj : Thanks, I did see that! My 'huntch' is that it's to do with Active Directory authentication tickets that are being rejected - maybe because of a time sync issue between the servers. But this is just a guess and I'd like something to back that up... – Guy Nov 21 '11 at 11:05
I do not think this is (directly) kerberos-related. This would be rather something about the SMB session to the destination's server share. Can't you back up locally and copy the backup files after this as a workaround? – the-wabbit Nov 21 '11 at 23:21
@syneticon-dj : 50+ SQL instances and several hundred databases and in the middle of the night? I need my beauty sleep mate! It seems to be a temporary glitch thing, and my script will just try again in 10 minutes or so. But I do get error message emails for every fail and, well, I shouldn't be getting these errors! – Guy Nov 22 '11 at 13:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.