resource database - move or not?

Question

resource database - move or not?

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

torpkev SSCarpal Tunnel Points: 4819 More actions · Answer 1

not sure how doing that would be any different to what i've already done, apart from splitting the log files away for master, msdb, model and tempdb

come the service pack, they wont be in the 'default' location which is what I thought I was being told would be bad..?

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

I long for a job where my databases dont have any pesky users accessing them 🙂

george sibbald SSC Guru Points: 104210 More actions · Answer 2

if you leave an install to 'default' (don't go into advanced option) system dbs end up in c:\program fies.

for an upgrade, the default will be wherever the registry says your master database is currently......

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

torpkev SSCarpal Tunnel Points: 4819 More actions · Answer 3

i know on a new install i can change the location..

but otherwise you're saying that I should move master to somewhere else, and that will be considered the default?

so come service pack day.. if master was in Z:\Data (for example). and all my other system db's are here.. i shouldn't have an issue, as it'll replace the resource database in the default (Z:\Data), which is exactly where i want it?

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

I long for a job where my databases dont have any pesky users accessing them 🙂

GSquared SSC Guru Points: 260824 More actions · Answer 4

torpkev (9/12/2008)
i know on a new install i can change the location..
but otherwise you're saying that I should move master to somewhere else, and that will be considered the default?
so come service pack day.. if master was in Z:\Data (for example). and all my other system db's are here.. i shouldn't have an issue, as it'll replace the resource database in the default (Z:\Data), which is exactly where i want it?

They just have to be in the same location. What location doesn't matter much, so long as it's the same.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

torpkev SSCarpal Tunnel Points: 4819 More actions · Answer 5

Thanks!

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

I long for a job where my databases dont have any pesky users accessing them 🙂