November 16, 2009 at 1:08 pm
I'm at a small company, new, and the ones who built the system aren't here anymore. Trying to straighten some things out and solidify some things. One thing I noticed is that there's one SQL Server (2005) server, and the 8 Dbs on it are backed up regularly, but nothing for failover. I'd like to set up another server for mirroring, just in case.
I have a couple of questions:
1. In a small company like this (100 employees, maybe 30-50 users; less than 20 servers), would it be a good idea to use a VMWare instance for the mirror server?
2. Do I need to buy an additional license for SQL Server if it's just a mirror?
November 16, 2009 at 1:12 pm
1. Yes you could do that. This could be a very solid solution, so long as it is a stable environment. If you should need to use this instance, you need to make sure that the VM can handle it.
2. You will need an additional license for the mirror - if it is hosting production databases. If it is not serving up production then see Gus's comment. If you decide to use a witness, you can get away with using the Express edition (no super fancy hardware required either).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 1:14 pm
Per the Microsoft license, you can have a copy of Windows Server and SQL Server that's the same edition or lower than your production server, for a failover backup, so long as it's an Active/Passive set up. So, yes, you can do that without an extra license.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply