sql server中密码和媒体密码的区别是什么？ [英] What is the diffence betwee password and media password in sql server?

问题描述

Hii ,,





请解释sql server中密码和媒体密码之间的差异？

当我们使用



1.备份数据库mydb

DISK = N''C：\ mydb.bak''

INIT

，mediapassword =''sqlpass''

，NAME =''完全备份mydb'';



2. 1.备份数据库mydb

DISK = N''C：\ mydb.bak''
带有INIT的


，密码=''sqlpass''

，NAME =''完全备份mydb'';



请说明差异..



thanx。

Hii,,


Please explain diffence betwee password and media password in sql server?
as we use

1. BACKUP DATABASE mydb
TO DISK = N''C:\mydb.bak''
with INIT
,mediapassword = ''sqlpass''
,NAME = ''Full Backup of mydb'';

2. 1. BACKUP DATABASE mydb
TO DISK = N''C:\mydb.bak''
with INIT
,password = ''sqlpass''
,NAME = ''Full Backup of mydb'';

please explain the difference..

thanx.

推荐答案

密码：



如果为备份集定义了密码，则必须提供密码才能执行任何SQL Server还原操作。但是，备份集密码不能保护备份文件不被覆盖。为防止备份文件被覆盖，请使用媒体设置密码。



mediapassword：



如果为媒体集定义了密码，则必须先提供密码，然后才能在该媒体集上创建备份集。此外，还必须提供该媒体密码才能从媒体集执行任何恢复操作。只有通过重新格式化才能覆盖受密码保护的媒体。

password:

"If a password is defined for the backup set, the password must be supplied to perform any SQL Server restore operation from the backup set. A backup set password does not protect the backup file from being overwritten, however. To prevent a backup file from being overwritten, use a media-set password instead."

mediapassword:

"If a password is defined for the media set, the password must be supplied before you can create a backup set on that media set. In addition, that media password also must be supplied to perform any restore operation from the media set. Password-protected media may be overwritten only by reformatting."

这篇关于sql server中密码和媒体密码的区别是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！