MSSQL 2005 Password protected backup - not restoring

[northrd]

Help!!!!
I have a backup that I have created using vb 2005 with a password of "!cp0p#Adm1n1strat0r". Now, when I go to restore it I am told that the password is invalid. I am guessing that it is the "!" and "#" causing problem. any ideas on how I can resolve this?

Cheers

 

[Jamfool]

Just had a quick check for you but the following seems to work fine.

BACKUP DATABASE [abc] 
TO  DISK = N'abc.bak' 
WITH NOFORMAT, NOINIT,  NAME = N'abc-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
,PASSWORD = '!cp0p#Adm1n1strat0r'

RESTORE DATABASE [abc] FROM  
DISK = N'abc.bak' 
WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10
,PASSWORD = '!cp0p#Adm1n1strat0r'
GO

 

[northrd]

Thanks.

 

[northrd]

Oh boy. Mediapassword <> password!!!!!!! I am an eedjit.

Thanks for your time on this