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 |
|
Mick
Starting Member
2 Posts |
 Posted - 2008-02-06 : 21:59:39
|
| I am trying to run a program called NVivo7, which - when I install - also requires installation of SQL Server. Because my C drive is small (and nearly full), I am trying to run NVivo7 off my D drive, though SQL seems to install on C. Is it possible, do you think, to use 2 different drives in this way, or do both the program and the Server need to be on the same one? If so, is there any way to get them both on D? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-06 : 23:04:15
|
| Yes, you can put most of sql on other drive than c:\. |
 |
|
|
Mick
Starting Member
2 Posts |
Posted - 2008-02-07 : 00:49:29
|
quote:
Originally posted by rmiao
Yes, you can put most of sql on other drive than c:\.
Thanks for this advice. I have tried moving SQL to my D drive, but now the installation (of Express, it seems) fails because of missing files: ‘sqlwriter.msi’, and ‘sqlncli.msi’. Any ideas? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-07 : 00:52:06
|
| You can't move the files to a different drive without severely messing things up. You must select the correct drive at installation time. Even if you select the D drive in the installation, the installer will still put a lot of files on the drive where the OS is installed, which is typically the C drive. Once you get service pack 2 installed, you'll see that SQL Server requires quite a bit of gigabytes on the OS drive even if you've told it to install it elsewhere.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Different drives