Post reply

what is certificate and its usage

  • March 16, 2013 at 12:08 pm

    #272258

    I want to have more clearity on what certificate actually holds.when to use it preferably.

    BACKUP CERTIFICATE sales09 TO FILE = 'c:\storedcerts\sales09cert'

    WITH PRIVATE KEY ( DECRYPTION BY PASSWORD = '9875t6#6rfid7vble7r' ,

    FILE = 'c:\storedkeys\sales09key' ,

    ENCRYPTION BY PASSWORD = '9n34khUbhk$w4ecJH5gh' );

    GO

    in the above code certificate is getting stored in the path mention but what is

    "with private key "means????

    can anyone explain??

  • March 16, 2013 at 12:12 pm

    #1597839

    Did you read all the certificate-related pages in Books Online?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 16, 2013 at 11:37 pm

    #1597861

    yes.but still not got clear abt it??

  • March 17, 2013 at 2:22 am

    #1597863

    What is it you are not clear on?

    Do you understand the concept of public and private keys?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply