I’m not sure what precisely you want to install, I suppose you mean a NAV database. Is this refering to a productive NAV system? Or is it just some kind of test/dev-environment?
If you are asking “Where to install a productive NAV database on SQL Server 2005” then I’m afraid, the requirements are more “challenging” than just 2 partitions! Depending on the expected database size and transaction volume, a minimum setup could look like this:
C:\ RAID1 Operating System, Swap file
D:\ RAID1 SQL Server Programs, maybe databases: master, model, msdb
All drives are physical drives, no logical partitions. Of course, this could be discussed, but I hope it points out that just two partitions are not fulfilling the SQL Server’s requirements.
If you were talking about a test setup, then it does not matter where the database is located if you have just logical partitions, but you can not expect good performance (depending on the load). If D:\ is another physical drive, then install the db here!
Sounds to me like you want to install SQL 2005 as well as SQL 2000 on your PC/laptop, which should work either way, depending that there is enough room on either partition for the installation files. Make sure SQL 2005 is the developer edition, otherwise it will try to upgrade your SQL 2000 installation.
I will explain more about my question and sorry because my question was not enough clear.
I am asking about installaion the SQL Server Managment studio in SQL 2005
which is enterprise Manager in SQL SEVER 2000 .
Really I have installed a tested phase of all the SQLSERVER 2005 collection from Server management studio to Reporting services that works with navision .and the testing was well … I have installed the sql engine on C: / where windows servwer 2003 is installed … and the navision databases on other partions …
Till now fine …Now I am repeating the installation on other computer …getting only 10 GB on C: where also Win server 2003 has been installed … My Questions in very clear way are ?
Remeber C: / where windows servwer 2003 is installed
Question 1 : Can I install the SQL management studio Engine with SQL Business intellegient Development with VB 2005 with all tools on another partion of C: ? Becuase I am supposing 10 GB will not be enough …
Question 2 : It’s more advisable to install the SQL management studio Engine with SQL Business intellegient Development with VB 2005 in the same place where the operating system has been installed ?
Question 3 : Is 10 GB enough to install the SQL management studio Engine with SQL Business intellegient Development with VB 2005 …and .of course the navision databases will be on other partitions .
i am repeating my thanks … and hoping to get my question in clear way this time .