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...

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,...

PaulB (9/12/2008)

---

You can take out the "probably" from your phrase, when the Service Pack day comes...

i guess sometimes the simplest solution is the one that works.. i moved the distmdl files while it was down, and i restarted just fine.

I understand your point of not...

george, over the top or not.. thats the standard we have, so I'm not about to change it. Personally, I feel better having them on seperate drives.

anyway... I'm still...

i read something about that.. which is why i broke my own rule and put the .ldf in the same drive/directory as the .mdf

ok so i managed to move the mssqlsystemresource database..

now the only one left in this drive is distmdl

i've read what its for.. but not sure how i can move it...

i moved my master database.. the only reason i wouldn't move the resource database is because its a damn pain to move

that being said, i did get it altered by...

Thanks Carl..

still not sure why the microsoft link i had didn't work as expected, but I'll try the detach method... AFTER i reinstall sql sever.

thanks again!

working from home would be nice.. then all I'd have to do is either bring my laptop home, or use my own computer with a vpn client.. all my stuff...

Thanks for the suggestions..

Personally I find SSMS works just fine for me, but just wanted some options. I'll take a look at some of the other tools out there....

actually im a brit living in the US.. but same concept i spose 😀

sharon.bender (8/4/2008)

---

I live in Australia, and I travel a half hour by car AWAY from the city, so I don't really have any traffic.

However, I also have permission to spend...

Runcorn bridge can be a nightmare some days.. though defo better than the tunnels

i hate you 😛