Quick Question.

Question

Quick Question.

Minnesota - Viking

Hall of Fame

Points: 3469
More actions
December 5, 2010 at 2:48 pm

#242157

We all know that Production DBs are kept on a different server than Dev or Rep.
If i want to mirror the DBs on Prod server where do i keep the mirror ?
I have 3 Servers (Prod, Dev, Reporting)
Please suggest. I know its a dumb question bt.. 😛
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

allin1 (12/5/2010)
If i want to mirror the DBs on Prod server where do i keep the mirror ?

On a second production server. They're production databases and should the principal fail that server will become the production server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Minnesota - Viking Hall of Fame Points: 3469 More actions · Answer 2

So, is there any other way to do it ? if we cannot afford a second production server?

[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

If you put the mirror onto reporting or dev, think what will happen if there's a failover and the reporting or (heaven forbid) dev server is hosting the active production databases with full production load. Think about hardware capabilities, think about security. As you said, production needs to be a separate environment.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Minnesota - Viking Hall of Fame Points: 3469 More actions · Answer 4

Thanks for the valuable feedback. I have one more follow up question, assuming that i have a stand by server to mirror the prod DBs and the server is in the Prod Network.

Niw Do I have to buy two licenses (2 X 25k $) OR since this is a type of failover I am safe installing in on the standby server server as long as querries are not being executed against the standby server ?

[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

Not a lawyer, but my understanding is that standby servers not being used do not need a separate license.

Yuri55 SSCrazy Eights Points: 8449 More actions · Answer 6

Just to confirm what Steve said- as per MS:

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

"A passive server does not need a license if the number of processors in the passive server is equal to or less than the number of processors in the active server."

But keep in mind that "The passive server can take the duties of the active server for 30 days. Afterwards, it must be licensed accordingly.

"

Minnesota - Viking Hall of Fame Points: 3469 More actions · Answer 7

Thanks Guys.

It Makes sense now.

[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]