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...