PLease help me in my task where i have to remove cloning of ldf files on SQL Server 2012.
I am a novice in such activities.
I have tried some of the below methods but all in vain.
CREATE DATABASE AConfig_Test1
ON (FILENAME=<path and mdf file name>
EXEC sp_attach_single_file_db @dbname='AConfig_Test1',
CREATE DATABASE AppConfig_Test1 ON
( FILENAME = 'path\filename.mdf)
All these threw the below error:
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "<path>\AppConfig_Test1.LDF". Operating system error 5: "5(Access is denied.)".
File activation failure. The physical file name "<path>\\AppConfig_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 'AppConfig_Test1'. CREATE DATABASE is aborted.