Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
backup using stored procedure: "Warning: @<> has not been specified as a unicode string."
Description
All existing backup Stored procedures now give this error message when they run: "The @encyptionkey being passed to the dbo.xp_backup_database SP is a nvarchar."
We have recently upgraded from version 6.x to version 8.7.
Cause
Upgrading does not redo any scripts you may be using. You always run the risk of having old maintenance plans not convert when you upgrade from a very old versions of LiteSpeed to the most recent version
Resolution
If you are getting an error about a parameter such as the below (in this example case it was @encryptionkey, but it may be different for you):
@encryptionkey = '12345ABCDE',
Then change it to be like the below, so that it has the "N". That will make it a unicode string, which is what LiteSpeed seems to now require in this recent, upgraded version:
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
LiteSpeed for SQL Server
Topic(s):
Configuration
Article History:
Created on: 6/29/2018 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
