Home Dashboard Directory Help
Search

SQL Server 2008 R2 SP2 installation does not handle renamed master/MSDB data files by JEMeyer


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 765892
Opened: 10/3/2012 6:00:58 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

On an SQL Server 2008 R2 SP1 system we renamed the data files for the MSB and master databases to adhere to our internal corporate standards, i.e. master.mdf was changed to master_data.mdf and the corresponding logical name was chanegd to master_data.
However, this breaks the SQL Server install/upgrade script "sqlagent100_msdb_upgrade.sql". This script contains hard-coded references to the master.mdf file and the MSDBLog logical file name for the MDSB log file.
I have not found documentation stating that renamign logical/physical fiel anme sunder SQL Server 2008 R2 is not supported.
Details
Sign in to post a comment.
Posted by Microsoft on 10/29/2012 at 11:04 AM
Hello
The general rule is that you shouldn't align system schema to match your corporate standards. So I will mark this defect as documentation defect and hopefully by next SQL 2008 R2 documentation refresh release we will have this issue documented.

Thank you
Alex Grach [MSFT]
Posted by Microsoft on 10/29/2012 at 10:42 AM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.