Rainbow002
asked on
how to separate location of sysdb from installation files during installation?
In sql srv 2000, there were options during the installation to specify wehre the installation and DBs should go. I'm not seeing this in sql 2005 enterprise edition during installation. Isn't there a performance gain to separate the installation files from DBs? What's the best practice for sql srv 2005?
ASKER
But what about systems databases? Wasn't it a best practice in sql 2000 to have program files and system databases in separate partitions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok so how do I separate them? If I'm giving file path of C:\mssql prog files will come here also the system databases are created here under C:mssql\data but I wan't change this to go to D drive? any idea?
This may be one reason you no longer see that option.