Solved

database restore error

Posted on 2006-11-17
4
1,301 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:crishna1
  • 3
4 Comments
 
LVL 29

Expert Comment

by:Nightman
Comment Utility
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
 
LVL 29

Expert Comment

by:Nightman
Comment Utility
Post your entire T-SQL statement here for me to correct if that doesn't help.
0
 

Author Comment

by:crishna1
Comment Utility
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
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
Comment Utility
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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now