Return
-
Title
Restore Error: "Incorrect syntax near the keyword 'percent'." -
Description
When restoring, you may encounter the folloing error, even if the restore completes successfully.
Database 'QuestDB' running the upgrade step from version 539 to version 551.
Msg 156, Level 15, State 1, Procedure _v_dz_Morig_bk, Line 2Incorrect syntax near the keyword 'percent'.This is the clean restore:Processed 11180216 pages for database 'QuestDB', file 'QuestDB_Data' on file 1.Processed 157910 pages for database 'QuestDB', file 'QuestDB_Log' on file 1.RESTORE DATABASE successfully processed 11338126 pages in 1463.665 seconds (63.458 MB/sec).Database 'QuestDB' running the upgrade step from version 610 to version 611.Database 'QuestDB' running the upgrade step from version 609 to version 610.Database 'QuestDB' running the upgrade step from version 608 to version 609.Database 'QuestDB' running the upgrade step from version 607 to version 608.Database 'QuestDB' running the upgrade step from version 606 to version 607.Database 'QuestDB' running the upgrade step from version 605 to version 606.Database 'QuestDB' running the upgrade step from version 604 to version 605.Database 'QuestDB' running the upgrade step from version 597 to version 604.Database 'QuestDB' running the upgrade step from version 593 to version 597.Database 'QuestDB' running the upgrade step from version 590 to version 593.Database 'QuestDB' running the upgrade step from version 589 to version 590.Database 'QuestDB' running the upgrade step from version 554 to version 589.Database 'QuestDB' running the upgrade step from version 553 to version 554.Database 'QuestDB' running the upgrade step from version 552 to version 553.Database 'QuestDB' running the upgrade step from version 551 to version 552.Database 'QuestDB'
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.