Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darsh123
Starting Member
3 Posts |
 Posted - 2012-04-07 : 15:36:35
|
| Hello,My client currently wants to Migrate SQL Server production instance from an outsourced vendor and bring it to in house. Currently the database is at outsourced location and is running on a clustered environment.The system details at high level are - SQL Server 2008 sp2 running on Windows Server 2003 Sp2.Now, my client wants to bring this setup in-house and the plan in nutshell is to create a parallel environment onsite. We are thinking to first cold restore with data files from outsourced location and then set up replication for concurrent synch up of offsite and newly created onsite instance. And then, this replicated new onsite instance need to be brought under clustering.The question for gurus on this forum, is there any comprehensive, step-by-step style document anywhere that addresses this replication/clustering in detail manner?Our onsite system configuration will be identical to outsourced location - i.e. SQL Server 2008 sp2 running in Windows Server 2003 sp2.ThanksD |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2012-04-26 : 18:52:33
|
| You could either use Replication or Database Mirroring from the remote site to on-premise instance.Actual installation is pretty straightforward..Use your favourite search engine to lookup step by step installation for (1) Windows clustering service (2) Creating a SQL Server 2008 failover cluster(3) Configuring Database mirroring/Replication from database backupIf you have a test system you can play with, you could follow the instructions and create a working document customized to your environment to make the actual transition as smooth as possible.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Server 2008 Migration, Replication and Cluster