Forum Discussion

Copper Contributor

Jan 18, 2023

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

olafhelper

Bronze Contributor

Jan 19, 2023

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_Wedman

Copper Contributor

Jan 19, 2023

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

olafhelper
Bronze Contributor
Jan 20, 2023
That 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