Forum Discussion
Lisa_Wedman
Jan 18, 2023Copper Contributor
SQL Server Capability Quesiton
Is there a special SQL Server product (and is there feasibility) that could be installed on one VM and house many databases (ie Microsoft Sharepoint database, Solar Winds database, Microsoft Exchange). Would this SQL server have capability to replicate and be backed up?
3 Replies
Sort By
- olafhelperBronze Contributor
Lisa_Wedman , sure there is: Microsoft SQL Server
Of course you can host serveral databases on on SQL Server instance, up to 1,024.
And of course you can backup/restore database.
Replication is also available.
Olaf
- Lisa_WedmanCopper Contributor
Thank you Olaf. Do I need a special version of SQL (ie Enterprise Edition), also do I need to configure the environment like a SQL Server Farm or will Clustering suffice? Are there any contingencies to this environment in a virtual platform?olafhelper
- olafhelperBronze ContributorThat mainly depends on your requirement, database sizes, count of users, workload, and much more.
You can start with the free SQL Server Express for first tests
https://www.microsoft.com/en-us/sql-server/sql-server-downloads