var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Attach database fails
Folks, i had a database with data and log file on seperate disks. After reboot, i've lost the log file; now i am trying to attache the data file using EM and QA, i get the following error; plz guide:
sp_attach_single_file_db 'production', 'd:\production_data.mdf'
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'production'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\production_log.LDF' may be incorrect.
Last edited by thebeginner; 09-20-04 at
try this...creat an empty database with that name...then detach it, and then try you attach
Hi Brett, same error. If i give the logfile for newly created database(as u suggested) i get the error can not associate files from different databases.