asked on

Importing Bak file into Sql Express

Hi I am having problems importing a backup file of a MS Sql database into Sql express.

I do the following query

RESTORE DATABASE db168338286 FROM DISK='C:\sitebook\oct8bkup.bak'
WITH MOVE 'Data_File' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\db168338286.mdf',
MOVE 'Log_File' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\db168338286_log.LDF'

i then get the error

Msg 3234, Level 16, State 2, Line 1
Logical file 'Data_File' is not part of database 'db168338286'. Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

when i restore filelist as below

RESTORE FILELISTONLY FROM DISK = 'C:\sitebook\oct8bkup.bak'

I get

db168338286      e:\mssql2000\MSSQL\data\db168338286.mdf      D
db168338286_log      e:\mssql2000\MSSQL\data\db168338286_log.LDF

I am trying to import the database to my laptop so i have a portable version of a web app i'm developing. I should have mentioned that the backed up database is on the web.

Not sure if its worth noting, but my laptop doesn't have an E;\ only C:\

Please Help.

Thanks

ASKER CERTIFIED SOLUTION

Yveau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

andrewdickie

ASKER

Excellent Response, now when i look at, i think i'm such a dummy. Cheers for your help.

Yveau

Glad I could be of any help and thanks for the grade !