backup media / set - password protection
From: chaiyun (chaiyun_at_hotmail.com)
Date: 06/26/03
- Next message: chaiyun: "Re: backup set / backup media password protection"
- Previous message: Shamim: "MultiServer Setup"
- In reply to: Paul: "backup media / set - password protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 25 Jun 2003 18:27:07 -0700
Thanks a lot. I resolved the issue by putting in the
following code into my schedule job :
BACKUP DATABASE C
TO DISK = 'd:\backup\C_Backup.bak'
WITH
NAME = 'C_Backup' ,
MEDIANAME = 'd:\backup\CBackup4.bak',
MEDIADESCRIPTION = 'Daily Backup File',
MEDIAPASSWORD = 'MyPassword',
INIT
>-----Original Message-----
>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: chaiyun: "Re: backup set / backup media password protection"
- Previous message: Shamim: "MultiServer Setup"
- In reply to: Paul: "backup media / set - password protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
