In your OP you state you are running SQL 2005.
Can you post the version info?
Select @@version
Can you also post the result of this ?
select MKP.*
, D.name as DbName
from sys.master_key_passwords MKP
inner join sys.credentials C
on MKP.credential_id = C.credential_id
inner join sys.database_recovery_status DRS
on MKP.family_guid = DRS.family_guid
inner join sys.databases D
on DRS.database_id = D.Database_id
;
I'll be using this art.to make a repro of your situation.
Laurentiu Cristofor's blog http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx
For the moment I'm at the point whe I restored the db on a second server and get the execution error:
Msg 15581, Level 16, State 3, Line 8
Please create a master key in the database or open the master key in the session before performing this operation.
I'll be back 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me