How to restore secured database

Question

0.00/5 (No votes)

See more:

I've took backup long ago using MediaPassword; and now i want to restore but forgot the password.
Is there any way to bypass the password and restore the database?

Posted 10-Feb-14 1:39am

sahabiswarup

Add a Solution

Comments

Kornfeld Eliyahu Peter 10-Feb-14 7:43am

No...

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)

Andrius Leonavicius · Accepted Answer · 2014-02-10T03:22:00

Solution 1

Hi,

The answer is no, unless you crack it...

MEDIAPASSWORD: "The protection provided by this password is weak. It is intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users. It does not prevent the reading of the backup data by other means or the replacement of the password." - Microsoft. The data in the backup sets is not encrypted and could be examined by some programs...

Advice: Try to recall the password (again). Maybe it is the same as SA password...?

Posted 10-Feb-14 3:22am

Andrius Leonavicius

Comments

sahabiswarup 10-Feb-14 22:58pm

Is there any way to bypass or crack that?

Andrius Leonavicius 11-Feb-14 18:23pm

Yes, it's possible to get the data from backup, secured with PASSWORD or MEDIAPASSWORD. That's why this feature is deprecated in SQL Server 2012.

If I were you, I would try some software, which could recover (extract) data from .bak file...

sahabiswarup 13-Feb-14 1:24am

Thanks for your suggestion, i've found this
http://www.stellarinfo.com/database-recovery.htm

But this is not free. Anyway if you have any free tool please share the link.

Andrius Leonavicius 14-Feb-14 19:30pm

You're welcome. Unfortunately, I don't know any free tool for this.