Importing Bak file into Sql Express
Posted on 2007-10-12
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'
db168338286 e:\mssql2000\MSSQL\data\db168338286.mdf D
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:\