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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-09-19 : 02:20:16
|
| Hi,At present there is no windows server machine in the company.I would like to install sql server 2005 standard edition on a windows xp pro machine.1)Can this sql server 2005 standard edition on xp pro be our main central sql server 2005 which holds all databases and instances in the company where other machines can connect to?2)The idea is that in the future when the windows server machine has arrived, I will then install sql server 2005 edition on that windows server machine and move the existing databases from the the current central xp pro machine to it.3)IS it best to instal standard edition on windows server only?Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-19 : 02:55:38
|
| 1. yes2. ok3. Yes, it would be best to put sql on a server OSDesktop OSes are tuned for running desktop apps. Server OSes are designed to run server class apps like SQL Server. For a small system this might be an ok solution, but you will be better off with running SQL on a server OS.The most important thing will be backups. Don't make the mistake of not implementing backups and make sure to test them regularly.-ec |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 02:59:12
|
quote:
Originally posted by eyechart
The most important thing will be backups. Don't make the mistake of not implementing backups and make sure to test them regularly.
Are you trying to put us out of business, James? 
E 12°55'05.25"N 56°04'39.16" |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-19 : 03:09:37
|
quote:
Originally posted by PesoAre you trying to put us out of business, James?
I should probably edit that out of my post then, huh?  -ec |
|
|
|
|
|
|
2005 standard edition on xp pro