help with install 1

[patrichek]

Hi,
this will be my first real install of ms sql server. currently we have the desktop engine version installed on our w2k3 server that came with our software and we are rapidly approaching db capacity.
can i just upgrade to standard edition or is it a whole new install? also, will i have to manually configure anything or will ms sql find the dbs and connect automatically?
thanks for the help!

 

[Luvsql]

Here's what you do: Rename your data and log directories. Uninstall SQL. Install SQL Standard to the same location as old install. Stop sql services, Rename new and rename the one you renamed before to Data (or whatever you had them named as). REstart sql services. YOu should be live now on standard with all databases.

 

[patrichek]

Hi,
thanks for the response! Can i just rename the folder than holds the data and logs?
Also, I'd like to move the dbs to another partition because whomever set this up originally put it on the c: drive and there's not much disk space there.
how should i proceed?

thanks again!

 

[Luvsql]

You can use the detach and reattach procedures ie detach, move the mdf file, then attach and point to new directory. Do you need to move the master and msdb databases?

 

[patrichek]

hi again,
yes, all the sql files/dbs are in the same directory.
so,it sounds like i need to first rename the data and log directories, uninstall ms sql desktop engine, install ms sql standard edition on drive c: (same location), rename the directories back to the original names then detach and move and reattach, correct?

 

[Luvsql]

You only need to detach and reattach if you are going to move the database/log files to a new partition.

 

[patrichek]

hi,
last night on my test server i set it up like my current production server, once up i selected "upgrade" instead of uninstalling, it seemed to work ok. Have you ever simply upgraded?

thanks for all your responses!!

 

[patrichek]

Thanks! it worked like a charm. the only problem i ran into was selecting how to authenticate. in the end i chose windows and ms sql authentication.

your help was GREAT!

 

[Jomercat]

Patrichek,

Choose windows and ms sql authentication if users from systems other than windows will be connecting to the SQL server. If only windows systems will be connecting, you should change it to Windows authentication.

Jose.