CREATE DATABASE .... FOR ATTACH_REBUILD_LOG does not work propely - by SQLpro

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


6
0
Sign in
to vote
ID 554612 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 4/27/2010 1:12:09 PM
Access Restriction Public

Description

When doing a move of all data file of a database without log files, the command CREATE DATABASE .... FOR ATTACH_REBUILD_LOG does not work properly when combined with a ALTER DATABASE ... MODIFY FILE of the log files.
The log files are rebuilded in the same directory as the database primary file instaed of the directory specified by the ALTER DATABASE ... MODIFY FILE command.

See sample below...
Sign in to post a comment.
Posted by Microsoft on 4/11/2011 at 9:58 AM
Hello,

Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this suggestion as “won’t fix”. If you feel that this is worth reconsidering, feel free to respond to this message and we will take another look.

Jan
SQL Server Engine
Posted by Microsoft on 4/11/2011 at 9:58 AM
Hello,

Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this suggestion as “won’t fix”. If you feel that this is worth reconsidering, feel free to respond to this message and we will take another look.

Jan
SQL Server Engine
Posted by Sankar Reddy on 12/26/2010 at 7:14 PM
I tested this repro in DENALI and the log file for me is created in a separate folder which is the default log file location configured on this server. I think the behavior what I see is correct. My question to SQLPro is what is teh default log file location on your server?

I don't think the log file should be created on C:\LOGDB\ unless it is explicitly specified. The default log file location is teh right place for this file in this case.
Posted by Microsoft on 5/6/2010 at 4:02 PM
Thank you for reporting this problem to Microsoft. We are currently investigating this issue and evaluating it for fixing in the next release of SQL Server.