April 6, 2009 at 4:34 pm
A client gave me a "BKP" file and asked if I could export the data into a CSV. He wasn't entirely sure of the format, but based on the software he's running, and the "BKUP" at the start of the file, I'm assuming it's a SQL Server backup file.
I've worked with Oracle, MySQL & PostGreSQL, but this is my first time playing with SQL Server. I downloaded the 2008 trial and installed it w/out difficulty. Google yielded the following restore command:
RESTORE DATABASE db_new
FROM DISK = 'D:\db.bkp'
WITH MOVE 'db' TO 'D:\db_new.mdf'
When I execute that, I get the following error:
Msg 3279, Level 16, State 2, Line 1
Access is denied due to a password failure
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I'm assuming from that error that the backup file has a password. If not, what am I doing wrong? Do I have to create either/both of the databases before restoring?
TIA.
April 6, 2009 at 4:41 pm
You don't have to create the database, and yes, there's a password on the file.
Typically SQL backups have .bak as the extension, not BKUP.
April 6, 2009 at 4:45 pm
The file extension is ".bkp", but the first 4 chars in the file are "BKUP". Other posts here indicate that's a MS SQL backup file (although I don't know if there's a way to tell if it's a full, differential or transaction log backup).
The client doesn't know the password. Any cracking tools out there that work with backup files?
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply