I'm in the process of moving our creaking old SQL 2000 server onto a new VM with Windows 2008 and SQL 2005.
The current SQL server has been set up with multiple instances, pretty much one per application and the default instance used for everything else. There's 5 instances on there!
It seems like a silly question, but i'm not a DBA so there might be something I'm missing. There's no differences in editions or licensing.......so is there any reason someone set it up like this? It was a long gone predecessor, so cant ask them!
The current SQL server has been set up with multiple instances, pretty much one per application and the default instance used for everything else. There's 5 instances on there!
It seems like a silly question, but i'm not a DBA so there might be something I'm missing. There's no differences in editions or licensing.......so is there any reason someone set it up like this? It was a long gone predecessor, so cant ask them!