SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Renaming system databases


Renaming system databases

Author
Message
IT researcher
 IT researcher
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4178 Visits: 1798
Can I rename the physical name of both mdf and ldf files of system databases such as msdb,model and master?
Steve JP
Steve JP
SSChasing Mays
SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)

Group: General Forum Members
Points: 609 Visits: 328
IT researcher (4/27/2013)
Can I rename the physical name of both mdf and ldf files of system databases such as msdb,model and master?


Without breaking anything?? I very much doubt it.

Why do you want to rename only some of the system databases files in the first place?
george sibbald
george sibbald
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58808 Visits: 13706
Steve JP (4/27/2013)
IT researcher (4/27/2013)
Can I rename the physical name of both mdf and ldf files of system databases such as msdb,model and master?


Without breaking anything?? I very much doubt it.

Why do you want to rename only some of the system databases files in the first place?


+1 million.

I would not be surprised if the next patch failed spectacularly

---------------------------------------------------------------------
IT researcher
 IT researcher
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4178 Visits: 1798
I am changing file name of mdf and ldf file not database name. Does changing the MSDBData.mdf to MSDB.mdf cause problem?
Steve JP
Steve JP
SSChasing Mays
SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)

Group: General Forum Members
Points: 609 Visits: 328
yes we got that. But why do you want to change the names of the physical files????
george sibbald
george sibbald
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58808 Visits: 13706
I cannot think of any good reason to change system database file names and cannot guarantee it won't cause a problem either now or with some future change MS makes that makes an assumption about system database file names.

---------------------------------------------------------------------
Keith Langmead
Keith Langmead
SSC-Addicted
SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)

Group: General Forum Members
Points: 430 Visits: 428
I'd put money on it breaking future updates, considering how SQL 2005 would fail to install some updates if you simply moved the resources db to a different physical location than the master database.
var_hwr
var_hwr
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 155
Since it is not advisable to change system dbs physical file name. If you want to do it for fun Hehe then just use the below command:
alter database master modify file(name=<logical_name>,filename='<physical filename along with its path>')
And then you need to stop SQL services,change the file name at its physical position and then again start SQL services.
note: for master you need to change physical file name in start up parameter also.
:-)
george sibbald
george sibbald
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58808 Visits: 13706
varunlpu,

to move master you only need to amend the startup parameters, stop SQL, copy files to new location, and restart SQL.

(and then cross fingers) :-)

---------------------------------------------------------------------
baabhu
baabhu
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4131 Visits: 1218
I'm just curious to find what made you to think that renaming a system databases is option for you. :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search