Organising databases and servers

  • I'm going to be developing 3 or 4 small/medium size databases over the next year. Should I run them all in the same databases engine or create a separate SQL server instance for each one. What are the pros and cons?

    Thanks

    Jason

  • If you are intending to run all the databases on the same server when it gets to production I'd go for a single instance unless either you want the databases in different versions of SQL or if you want different groups of staff managing the different instances.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply