We are currently using an application which uses SQL Server 2005. Both sit on the same box.
This month we're adding another piece of software to our network on a new box which also depends on SQL Server. Since we don't have a directed attached storage device to store (as recommended by Microsoft), we're contemplating installing SQL Server again just for this application. Of course this means that we have to maintain two separate SQL Server databases.
Any thoughts on what we should do?
Thanks
Hi,
You can install and run two or more instances of SQL Server on a server. But this means increase in number of services and maintenance (like SP upgrades, etc). But if you have different instances, you can restart an instance without affecting the other.
If you think you may have such situations and your users (or customers) are different (so why they will bother for someone else's application), you can install as a seperate instance.
But you can configure your SQL Server security to give service to two different applications.
Eralper
http://www.kodyaz.com
No comments:
Post a Comment