BACKUP DATABASE PASSWORD

[password99]

hOW DO i SPECIFY THE PASSWORD FOR for the backup set? If I specify the PASSWORD option I get this error:

Server: Msg 3278, Level 16, State 1, Line 1
Failed to encrypt string -2146893809(Object already exists.)
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

If I remove the password option it works fine. This is a new file name that I am specifying (does not exist)

This is what I am calling:

BACKUP DATABASE pubs
TO DISK = 'C:\ALL\MYPUBS091203.DAT'
WITH
DESCRIPTION = 'pubs backup',
PASSWORD = 'mypassword' ,
NOFORMAT,
NAME = 'Full Backup of MyPubs'

 

[ClaireHCM]

why dont you do this and check it out what is object:2146893809?

select * from sysobjects where id = 2146893809