database restore error

Server: Msg 3279, Level 16, State 2, Line 1
Access is denied due to a password failure
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally

How do i pass the above? i have the passpwrd , where do i define it?

I am using Querry Analyser with Restore command

thanks
crishna1Asked:
Who is Participating?
 
NightmanConnect With a Mentor CTOCommented:
Replace 'password' with your password

restore database XXX from disk ='E:\XXX\sonytcamera_1000.bak'
with PASSWORD ='password',
move 'sony1_Data' to 'E:\Data\XXX_Data.MDF',
move 'sony2t_Log' to 'E:\Log\XXX_Log.LDF',
replace,stats
0
 
NightmanCTOCommented:
Often a specific password is created for the backup itself, preventing it from being restored without the correct password. This seems to be the case here. You need to know what the password was.

RESTORE DATABASE MyDB FROM DISK = 'C:\MYDB.bak' WITH PASSWORD='password' etc
0
 
NightmanCTOCommented:
Post your entire T-SQL statement here for me to correct if that doesn't help.
0
 
crishna1Author Commented:
restore database XXX from disk ='E:\XXX\sonytcamera_1000.bak'
with
move 'sony1_Data' to 'E:\Data\XXX_Data.MDF',
move 'sony2t_Log' to 'E:\Log\XXX_Log.LDF',
replace,stats
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.