0
votes
1answer
106 views

Sql Database Mirroring in a workgroup

I found an article explaining almost everything I need to know here: http://www.sqlservercentral.com/blogs/kendalvandyke/2011/12/01/database-mirroring-in-a-windows-workgroup/ The only difference ...
1
vote
2answers
340 views

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing i want to load balance my SQL workload all database insert update and delete queries will be mirrored all select ...
1
vote
1answer
451 views

Data migration from one data center to another - SQL Server 2005 / 2008

We're installing new data center and we'll set that location as primary location. What do you think, how should we migrate SQL Server data? System is normally active 24x7x365, but we're prepared for ...
1
vote
3answers
454 views

Sql Server Mirror over Internet

Ok, I'm gonna get some weird looks for this, but It's something I want to do. I have two servers on the internet, I want to open an internet port just for each others IP, and do a SQL Server 2008 ...