Check weither SQB file is encrypted

chenchen300

Hi
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?

RichardL

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. 

chenchen300

my mistake. i will repost it on the right board..
thanks!!!