What is the diffence betwee password and media password in sql server?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

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.

Posted 18-Apr-13 5:50am

Anupam Singh

Add a Solution

Comments

[no name] 19-Apr-13 0:48am

If I want to restore database with replace in other system .Can I face any issues ??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RedDk · Accepted Answer · 2013-04-18T07:20:00

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."