What are the challenges you face when working across database platforms? Take the survey

Check weither SQB file is encrypted

chenchen300chenchen300 Posts: 12 Bronze 1
edited May 1, 2018 7:22AM in SQL Backup
I have just start to encrypt the SQB files.
But the old ones has no password, so i need some technique to check if need use WITH PASSWORD clause or not. 
Is there a way to check if SQB file is encrypted?



  • Options
    RichardLRichardL Posts: 417 Gold 4
    Hi @chenchen300

    Thanks for your post. 

    Is your query about SQL Backup rather than SQL Prompt? 

    Kind regards

    Richard Lynch. 

    PS: There is an option to encrypt these files in SQL Backup if so so decide. It can have a password set for decryption. Passwords are set at the time of Backup. 
    Customer Support
    Redgate Software
  • Options
    chenchen300chenchen300 Posts: 12 Bronze 1
    my mistake. i will repost it on the right board..
Sign In or Register to comment.