backup media / set - password protection
From: Paul (Paul.Amarante_at_Diageo.com)
Date: 06/20/03
- Next message: Dan Guzman: "Re: sp_password"
- Previous message: Andrew J. Kelly: "Re: sql server connections"
- In reply to: chaiyun: "backup media / set - password protection"
- Next in thread: chaiyun: "backup media / set - password protection"
- Reply: chaiyun: "backup media / set - password protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 20 Jun 2003 05:40:25 -0700
If you do the backup from isql, instead of the Ent Mgr,
there ie
BACKUP Database 'dbname' to 'backup device' WITH password
= {password}
You can write a simple DOS batch program to call isql and
redirect this command to the isql session. I prefer to do
admin functions this way and stay away from any GUI tools
for these functions.
>-----Original Message-----
> I would like to find out in details how to apply
>password protection to the backup media for SQL Server
>Database backup. I check the SQL Server Online Books, but
>I am not too sure to proceed. Please help.
>.
>
- Next message: Dan Guzman: "Re: sp_password"
- Previous message: Andrew J. Kelly: "Re: sql server connections"
- In reply to: chaiyun: "backup media / set - password protection"
- Next in thread: chaiyun: "backup media / set - password protection"
- Reply: chaiyun: "backup media / set - password protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
