Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Renaming system databases Expand / Collapse
Author
Message
Posted Saturday, April 27, 2013 2:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:58 PM
Points: 270, Visits: 1,745
Can I rename the physical name of both mdf and ldf files of system databases such as msdb,model and master?
Post #1447233
Posted Saturday, April 27, 2013 3:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 5:53 AM
Points: 51, Visits: 296
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?
Post #1447237
Posted Saturday, April 27, 2013 3:49 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
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


---------------------------------------------------------------------

Post #1447242
Posted Saturday, April 27, 2013 4:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:58 PM
Points: 270, Visits: 1,745
I am changing file name of mdf and ldf file not database name. Does changing the MSDBData.mdf to MSDB.mdf cause problem?
Post #1447247
Posted Saturday, April 27, 2013 4:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 5:53 AM
Points: 51, Visits: 296
yes we got that. But why do you want to change the names of the physical files????
Post #1447248
Posted Saturday, April 27, 2013 6:18 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
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.



---------------------------------------------------------------------

Post #1447259
Posted Saturday, April 27, 2013 10:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 29, 2013 1:44 PM
Points: 144, Visits: 426
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.
Post #1447284
Posted Sunday, April 28, 2013 10:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:35 AM
Points: 2, Visits: 72
Since it is not advisable to change system dbs physical file name. If you want to do it for fun 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.
Post #1447333
Posted Sunday, April 28, 2013 2:17 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
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)


---------------------------------------------------------------------

Post #1447342
Posted Monday, April 29, 2013 12:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:26 PM
Points: 1,293, Visits: 1,127
I'm just curious to find what made you to think that renaming a system databases is option for you.
Post #1447379
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse