You can password protect the backup file e.g.use mastergobackup database pubs to disk='c:\pubssecure.bak'with password='foobar'gorestore database pubsfrom disk='e:\pubssecure.bak'with replace -- notice we haven't supplied the passwordgo
Because we haven't supplied the password we get errors :Server: Msg 3279, Level 16, State 2, Line 1Access is denied due to a password failureServer: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.If we supply the password, restore procedes normally :restore database pubsfrom disk='e:\pubssecure.bak'with replace,password='foobar'go
HTHJasper Smith