We have multiple SQL Server instances running on different servers in our organization, each requiring maintenance and backup. We have a vendor backing up these instances that charges on a per instance basis. I am doing a review to see if I can bring all those SQL Server DBs onto just one instance of SQL Server.
What should I watch for if I run multiple SQL Server DBs on one SQL Server instance? So far, I haven't had any issues. I know there must be enough disk space to hold multiple DBs. Other than size, however, does performance pose an issue? Please share your experience.
April 5, 2010 6:45 PM
April 6, 2010 3:19 AM