I'm trying to install a database (on a SQL Server 2008 machine) with test data sent by a partner company in the form of a .BAK file. (Version of SQL Server they are using unknown).
I'm using this script:
RESTORE DATABASE XEMS
FROM DISK = 'C:\temp\xemstest6-29.bak'
WITH REPLACE, MOVE 'XEMS' TO 'E:\XEMS DATABASE\XEMS.MDF',
MOVE 'XEMS_Log' TO 'E:\XEMS DATABASE\XEMS_Log.LDF'
The Restore process churns for a while, then I get:
Processed 2576 pages for database 'XEMS', file 'XEMS' on file 1.
Processed 5 pages for database 'XEMS', file 'XEMS_log' on file 1.
Msg 3283, Level 16, State 1, Line 2
The file "XEMS_log" failed to initialize correctly. Examine the error logs for more details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
At this point the database is unusable - trying to do anything with it produces an error indicating the database is still in a Restore state. There is some problem with the LOG portion of the backup, which I really don't need anyway.
I'd like to just NOT restore the log. Came across this article which seemed to refer to the exact problem I'm having...
They offered this suggestion:
"Use the WITH NO_LOG clause during the restore process."
However - in checking the RESTORE syntax....
View Complete Post