• Actully some other user has already created master key..

    I don;t have any idea who was he/she.

    Now the issue is i don't have password for it too. and that key is created with different algorithm.

    I have create one certificate under master database.

    but when I do backup it is aksing for open or create the master key.

    as matter of fact i can not create another master key and I don't have password to decreypt it and open it, I choosed anothe option too create the master key in different system db e.g. tempdb. just for testing the encyption with custome database.

    Your all suggestions and tips are welcome for future steps.

    thanks.