It depends on how incryption is setup and managed

I agree , these days with the rise in white collar crime all data should be treated as sensitive.

Yes you can do it via the commandline by using osql or sqlcmd depending which version of sql you are using.

SQL 2000 =osql

SQL 2005 =sqlcmd

use master

go

restore database dbname...

Thanks for all the tips.I think i wil setup sql 2005 in a vm enviroment and then do some testing over a period of a month and take it from...

this will might be a good way as a online archive solution

hi,

Which version of SQl are you using?