I have installed a SQL Server 2014 on a new machine
SQL 2005 runs on another
I did detach my test database from 2005, copied to d:\mssql\data (created by admin) on 2014 server
I did not copy the log from 2015 (to have it rebuilt by it)
Now with Studio on the 2014 machine , I issue this : exec sp_attach_single_file_db 'gmTest','d:\MSSql
I directly receive this error :
File activation failure. The physical file name "d:\mssql2005\data\gmTest_Log.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'gmTest'. CREATE DATABASE is aborted.
The thinks is that the full name specified is the one of the "old" server !
I suppose it comes from inside the data file
How shell I fix this ?