May 9, 2006 at 11:37 am
Dear All,
i am facing an error while restoring the backup of a database. but it gives me an error message:
SQL DMO ODBC SQLSTATE 42000
Access is denied due to a password failure VerifyDatabase terminated abnormally.
please help me what is this, where i have to enter the password bcz i know when the backup job run it apply a user name and pass. and i know the user and pass but not know where and how i can apply while restoring the DB.
waiting for replies.
Noman
May 9, 2006 at 12:59 pm
Refer to the BOL, use the index tab, enter RESTORE DATABASE, then choose the option that says Transact SQL.
Basically, you need to run the RESTORE like this:
RESTORE DATABASE dbname
FROM .....
WITH PASSWORD = 'password'
Replace the lowercase password with your actual password.
-SQLBill
May 9, 2006 at 1:31 pm
Thanx,
its restored.. by using the Script not through the wizerds. thanx any ways.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply