We have an SBS server running 4 Microsoft SQL 2008R2 instances. I need another for an anti-spam product, but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all the instances isn't an issue so can I just add a new database to an existing SQL Instance to get this running?
Asked
Active
Viewed 35 times
0
-
Most likely yes, but I would confirm with the product vendor. – squillman Sep 08 '14 at 20:42
1 Answers
0
Why do you have so many SQL instances? I'm not a DBA, but normally I've only seen named instances for situations where you're trying to run multiple environments on a single DB server (for example a dev and stage version of the same DB).
To answer your question, yes there should be no problem at all to add as many DBs as you need to any instances.
Falcon Momot
- 25,244
- 15
- 63
- 92
Eric C. Singer
- 2,329
- 16
- 17