Lost SQL Backup Password

[Bofh5]

Hi all
Does anyone know how to recover a sql backup that has been password protected.

I'm using this to restore the backup but it errors saying the password is wrong.

RESTORE DATABASE DB1 FROM DISK='\\MyServer\MyDirectory\DB1_Full20081022.BAK' WITH PASSWORD='password'

Thanks
____________________
(L)users...Disk space is to good for them.

Bikes: Honda 50 / CB125-TDC / 93 CBR600 F2 (Stolen & Trashed) / 2001 SP-1 (Sold) / 95 CBR600 F3

[Dalemac]

Best bet is to speak to your webhost.
____________________
YBR125 -> GPZ500S -> SL1000

[Bofh5]

webhost ???

I'm googling for password recovery tools

its a .bak file
____________________
(L)users...Disk space is to good for them.

Bikes: Honda 50 / CB125-TDC / 93 CBR600 F2 (Stolen & Trashed) / 2001 SP-1 (Sold) / 95 CBR600 F3

[duhawkz]

think some kind of password recover tool is going to be your best bet.

who set the password on it ?
____________________
"The guy is a worthless cunt and I honestly believe I would be a slightly happier person if he died." - Chris-Red

[Bofh5]

that is the problem...
no ones remembers who did the backup and what the password might have been.
not even a clue to its length or complexity.
____________________
(L)users...Disk space is to good for them.

Bikes: Honda 50 / CB125-TDC / 93 CBR600 F2 (Stolen & Trashed) / 2001 SP-1 (Sold) / 95 CBR600 F3

[duhawkz]

why do you need to restore the backup, is the original fubar?
____________________
"The guy is a worthless cunt and I honestly believe I would be a slightly happier person if he died." - Chris-Red

[Bofh5]

they want to restore a database from a few months ago for historical reasons.
____________________
(L)users...Disk space is to good for them.

Bikes: Honda 50 / CB125-TDC / 93 CBR600 F2 (Stolen & Trashed) / 2001 SP-1 (Sold) / 95 CBR600 F3

[Dalemac]

Yeah, have fun with that.
____________________
YBR125 -> GPZ500S -> SL1000

[duhawkz]

https://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/002f6c33-07be-4215-9de6-ca4e3f5d9bec/

[Bofh5]

Will give that a try.
Never fails to amaze how often this sort of thing happens.
Then its crying to IT to fix it.
____________________
(L)users...Disk space is to good for them.

Bikes: Honda 50 / CB125-TDC / 93 CBR600 F2 (Stolen & Trashed) / 2001 SP-1 (Sold) / 95 CBR600 F3

[UnknownStuntm...]

[duhawkz]

just incase you decide to set up a new backup with a password

https://keepass.info/
____________________
"The guy is a worthless cunt and I honestly believe I would be a slightly happier person if he died." - Chris-Red

[oldpink]

find the site config file
that should have the username and password for the DB in there
____________________
I have become comfortably numb

Theory & hazard 24-may 2016, CBT 8th June 2016, MOD 1 2nd Aug 2016 Mod 2 2nd-Nov 2016 - Current bike CBR 600 RR

[duhawkz]

its a not a DB, the db is on line and working

its a backup file, of a DB that they are trying to restore which somebody has password protected, and subsequently lost the password
____________________
"The guy is a worthless cunt and I honestly believe I would be a slightly happier person if he died." - Chris-Red