﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2012 / SQL Server 2012 -  T-SQL  / Remove cloning of ldf files / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Tue, 18 Jun 2013 14:58:28 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Remove cloning of ldf files</title><link>http://www.sqlservercentral.com/Forums/Topic1428557-3077-1.aspx</link><description>You need the original LDF, the DB was detached read_only so it will not allow you to create a new LDF for that DB, you need the one it was using when it was set to read only and detached.Also error 5 is access denied ensure you have the right permissions assigned to your service accounts.</description><pubDate>Fri, 08 Mar 2013 06:48:27 GMT</pubDate><dc:creator>anthony.green</dc:creator></item><item><title>Remove cloning of ldf files</title><link>http://www.sqlservercentral.com/Forums/Topic1428557-3077-1.aspx</link><description>Hi Experts,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=&amp;lt;path and mdf file name&amp;gt;) FOR ATTACH_REBUILD_LOGEXEC sp_attach_single_file_db @dbname='AConfig_Test1',@physname='path\mdffilename.mdf'GOCREATE DATABASE AppConfig_Test1 ON( FILENAME = 'path\filename.mdf)FOR ATTACHGOAll these threw the below error:Msg 5120, Level 16, State 101, Line 1Unable to open the physical file "&amp;lt;path&amp;gt;\AppConfig_Test1.LDF". Operating system error 5: "5(Access is denied.)".File activation failure. The physical file name "&amp;lt;path&amp;gt;\\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 1Could not open new database 'AppConfig_Test1'. CREATE DATABASE is aborted.</description><pubDate>Fri, 08 Mar 2013 06:43:28 GMT</pubDate><dc:creator>anupam.jha</dc:creator></item></channel></rss>