Simptomi
Kada instalirate Microsoft SQL Server 2014 s zadanim postavkama, svojstvo language je Engleski (Sjedinjene Američke Države) us_english, a zadani redoslijed za Datum je MDG. Ako se datumski poredak operacijskog sustava razlikuje od toga, kada postavite upravljano sigurnosno kopiranje u Windows Azure, prikazat će vam se sljedeće poruke o pogreškama nakon dovršetka sigurnosnog kopiranja: pogreška:
SqlError, kod = 242, Stage = nedefiniran, message = pretvaranje vrste podataka VARCHAR u vrstu podataka datetime rezultirala je vrijednošću izvan raspona. Naredba je prekinuta.
Snopa
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, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean 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. decimalni> ByRef, System. Nulda ' 1<System. GUID> ByRef, System. Nulda ' 1<System. decimalni> ByRef) na servisu Microsoft. SqlServer. SmartAdmin. SmartBackupAgent. SmartBackup. Dojoboutcomeverifikacija (Microsoft. SqlServer. SmartAdmin. Smartbackupag. AutoBackupDBData) na servisu Microsoft. SqlServer. SmartAdmin. Smartbackupag. SmartBackup. DoWork () na servisu System. Threading. ExecutionContext. RunInternal (Systethreading ContextCallback, sistemski. Object, Booleov) u sustavu. Threading. ExecutionContext. Run (Systethreading. ExecutionContext, Systethreading. Contextu sustavu System. Threading. Execucioncontext. trčanje (System. Threading. ExecutionContext, Systethreading. Context.
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
Svako novo Kumulativno ažuriranje za SQL Server sadrži sve hitne popravke i sve sigurnosne ispravke uključene u prethodno Kumulativno ažuriranje. Pogledajte najnovija kumulativna ažuriranja za SQL Server:
Status
Microsoft je potvrdio da se radi o problemu u Microsoftovim proizvodima navedenim u odjeljku "odnosi se na".
