Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
psfaro
Starting Member
49 Posts |
 Posted - 2010-06-21 : 13:19:21
|
| Hi,Is possible that the SYSTEM DATABASES (TEMPDB, MASTER) could be in other drive diferent that c: ?I know that users databases must be in other Partition diferent that OS, but what about the system databases?If so , it's a good pratice ?Regards Pedro |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-21 : 13:47:17
|
Trouble is that the MS installer used to default to putting the system databases in c:\program files\...which is pretty unforgivable, and must have lead to many-a-mess  |
 |
|
|
psfaro
Starting Member
49 Posts |
Posted - 2010-06-21 : 14:21:51
|
| Hi,In a production environment , if the system databases remain on c:, what is the best way to move them to other Partition drive ?Can we detach system databases like we do users databases ?Pedro |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database Master e TEMPdb