collie3
asked on
Database Server and SQL Setup Query
We currently have 3 seperate applications which have SQL databases, all installed on one windows 2003 server. We now have a fourth system which also requires SQL Server. I would like some advice on what is the best way to setup databases in SQL.
Would it be best practice to install the application on a seperate server and just link the database back to the database server.
Then to tidy this up...
Move all applications onto a seperate server and keep this server as just a database server.
How many databases can SQL Server 2005 standard handle before you setup a second database server?
I would like to implement a strategy now and tidy this up...
Thanks
Would it be best practice to install the application on a seperate server and just link the database back to the database server.
Then to tidy this up...
Move all applications onto a seperate server and keep this server as just a database server.
How many databases can SQL Server 2005 standard handle before you setup a second database server?
I would like to implement a strategy now and tidy this up...
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.