backup using stored procedure: "Warning: @<<parameter>> has not been specified as a unicode string." (4257331)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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:
@encryptionkey = N'12345ABCDE',

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title