SQL server environment
- by Olegas D
Hello
I'm considering a bit of changes in current sales environment. And trying to check all cons and pros.
Current situation.
SQL server (quite decent HP server - server1) + backup server (smaller Dell server - server2).
all sql files and sql server itself are on the server1. If something goes wrong with server1 I will have to manually move to server2.
Connecting to the sql server: 1 HQ (where server located) + 4 sites through VPN.
Now I'm considering 2 scenarios:
Buy some storage system + update existing servers (add ram, upgrade processors) and go for VMWare ESXI.
Rent a server at a datacenter + rent virtual server in case real server goes down. Also rent some space at data storage to keep SQL files there.
Have anyone considered these things and maybe found some good pros/cons list? ;)
Thanks