Simptomi
Kada instalirate Microsoft SQL Server 2014 sa zadanim preferencama, svojstvo jezika bit će engleski (SAD) us_english, a zadani je redoslijed datuma mdy. Ako se redoslijed datuma operacijskog sustava razlikuje od ovoga, kada postavite upravljanu sigurnosnu kopiju na Windows Azure, primit ćete sljedeće poruke o pogrešci nakon dovršetka sigurnosnog kopiranja:
Pogreška:
Napomena
SqlError, Kod = 242, Faza = Nedefinirano, Poruka = Pretvorba vrste podataka varchar u vrstu podataka datuma i vremena rezultirala je vrijednošću izvan raspona. Iskaz je prekinut.
Stog:
Napomena
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action'1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Booleov returnStream, Booleova asinkronizacija, Int32 vremensko ograničenje, Zadatak& zadatak, Booleov asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource'1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource'1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.SmartAdmin.SmartBackupAgent.FileService.InsertOneRowForHelperTable(SmartBackupFilesTableRow row, SqlConnection conn, Boolean& isDuplicate)
at Microsoft.SqlServer.SmartAdmin.SmartBackupAgent.FileService.GetLastLSNAndInsertToHelperTable(System.String, System.String, System.Guid, System.Nullable'1<System.Guid>, System.String, System.Nullable'1<System.Decimal> byRef, System.Nullable'1<System.Decimal> byRef, System.Nullable'1<System.Guid> byRef, System.Nullable'1<System.Decimal> byRef)
at Microsoft.SqlServer.SmartAdmin.SmartBackupAgent.SmartBackup.DoJobOutcomeVerification(Microsoft.SqlServer.SmartAdmin.SmartBackupAgent.AutoBackupDBData)
at Microsoft.SqlServer.SmartAdmin.SmartBackupAgent.SmartBackup.DoWork()
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) at System.Threading.ThreadHelper.ThreadStart()
Rješenje
Taj je problem prvi put riješen u sljedećem kumulativnom ažuriranju sustava SQL Server.
Kumulativno ažuriranje 5 za SQL Server 2014 /en-us/help/3011055
O kumulativnim ažuriranjima za SQL Server
Svako novo kumulativno ažuriranje za SQL Server sadrži sve hitne popravke i sigurnosne popravke koji su obuhvaćeni prethodnim kumulativnim ažuriranjem. Pogledajte najnovija kumulativna ažuriranja za SQL Server:
Status
Microsoft je potvrdio da je to problem u Microsoftovim proizvodima koji su navedeni u odjeljku „Odnosi se na“.