Hi..
We are trying to attach a database (MDF File without LDF File) in SQL2K SP4
MDF File is in HDS (Hitachi Data Storage) Lun or SAN Storage.
When we try attach the MDF File, we are getting an error. The error message is :
" Error 1813: Could not open new database 'Test'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\SQLData\Test_log.ldf' maybe incorrect "
When We try attach the MDF File, but We move the MDF File into Local Hard Drive (Drive C:), then We success to attached the MDF File and the LDF File is automaticlly generated without error.
i'm waiting for the solution
Thank's.
Brgds,
Dwiharto
How did you attach it? Try using sp_attach_single_file_db stored procedure instead.Whether the data file resides on the SAN or not should not matter here.|||
I had try it before, but it is still doesn't working and still had same error message.
btw thanks for ur advice.
maybe u can tell me another way?
Thank's a lot Friend ...
|||Can you post the exact attach statement.|||the statement :
sp_attach_single_file_db @.dbname = 'test',
@.physname = 'F:\SQLData\Test.mdf'
Thank's..
|||The statement looks valid. (F:\) is a locally attached SAN, right? If this is a network attached san, you need to turn on trace flag (1807). Also, does the account used to start sqlserver service has full right to the SAN?
