Return
-
Title
The attempt to enable varDecimal on the table failed when running OLR -
Description
Error when running Object Level Recovert (OLR):
Date xxxx
Log Job History (Litespeed_OLR_xxx)
Step ID 1
Server xxxx\xxx
Job Name Litespeed_OLR_xxx
Step Name Litespeed_OLR_Test
Duration 00:00:34
Sql Severity 16
Sql Message ID 60000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: xxx\xxxxx. LiteSpeed(R) for SQL Server Object Level Recovery 8.5.0.625 Copyright 2017 Quest Software Inc. ALL RIGHTS RESERVED. Table dbo.AFS_UnitTrades successfully recovered to table [LiteSpeedOLRTest].[dbo].[AFS_UnitTrades]. Table dbo.AFS_UnitTrades: 1130190 rows recovered. [SQLSTATE 01000] (Message 1) Warning: Table [LiteSpeedOLRTest].[dbo].[AFS_UnitTrades] will have normal Decimal formatted decimal values yet the original table had varDecimal enabled. The attempt to enable varDecimal on the table failed. Ensure the database is enabled for varDecimal to save space next time. Only supported for SQL Server 2005 SP 2 and up. There is no user table matching the input name '[LiteSpeedOLRTest].[dbo].[AFS_UnitTrades]' in -
Resolution
WORKAROUND
Enable varDecimal storage after the table is recovered.
STATUS
Waiting for fix in a future release of LiteSpeed for SQL Server.
-
Defect ID
LS-383