SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Using High Availability to move to a new server?


Using High Availability to move to a new server?

Author
Message
SQL-Squid
SQL-Squid
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 306
We have an existing windows 2003 server with sql 2008 r2 enterprise. Its part of a Hyper-V configuration.

A new windows 2008 server was purchased. I need to move all databases, jobs and user accounts to the new server. We are staying with the same sql 2008 version. (The new server will also use Hyper-V)

I do not want to manually detach, copy/restore & attach each and very database and job to the new server. Additionally, I would like to keep the old production system online and roll over in a quick manner.

I did some reading and would like to hear from you experts which High Availability method would be good to move to the new system. (I have setup mirroring, log shipping and fail over clustering in lab enviroments in the past)

Additionally, I have another question (it may be out of context for this forum, but its very related to my first question).
I have a old widows server 2008 with sharepoint 2010, and sql 2008, this whole setup is also being moved to the new windows 2008 server. With all the info on the web, any pointers where to look will be very appreciated!

Thanks in advance!
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20606 Visits: 17244
Just out of interet why is hyperv installed, are you hosting VMs on this box too?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
SQL-Squid
SQL-Squid
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 306
Yes, the whole enviroment is virtualized, no stand alone installs Wink
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1930
I do not believe it is possible for you to move the server objects (SSIS packages, customized jobs, etc) but you may re-create those (prior migration) and test. Actually, I am assuming you will test the migration anyway.

But yes, the databases can be migrated quickly using Mirroring.

I did it recently with several big databases and found no issues and it was to move from SQL2005 to SQL2008. The key is, ensure you have the same users on the other servers and you already reset the SSID. Once done, it takes a few seconds.
SQL-Squid
SQL-Squid
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 306
sql-lover (9/8/2012)
I do not believe it is possible for you to move the server objects (SSIS packages, customized jobs, etc) but you may re-create those (prior migration) and test. Actually, I am assuming you will test the migration anyway.

But yes, the databases can be migrated quickly using Mirroring.

I did it recently with several big databases and found no issues and it was to move from SQL2005 to SQL2008. The key is, ensure you have the same users on the other servers and you already reset the SSID. Once done, it takes a few seconds.


Thanks for the responce.

After some more research and testing I will be using mirroring. Clustering is out of the question, due to the servers being ver 2003 and 2008.

Mirroring is working very well!
chandan_jha18
chandan_jha18
SSC Eights!
SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)SSC Eights! (915 reputation)

Group: General Forum Members
Points: 915 Visits: 2134
Mirroring solution will work fine to minimize the downtime but please make sure that you have exact versions of sql server with exact level of service pack.

Thanks
Chandan
MysteryJimbo
MysteryJimbo
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2261 Visits: 15346
chandan_jha18 (9/11/2012)
Mirroring solution will work fine to minimize the downtime but please make sure that you have exact versions of sql server with exact level of service pack.

Thanks
Chandan


This is why logshipping is a better method of migrating/update database server as there are no restrictions. Logshipping is also guaranteed not to have an impact on the production server where as mirroring potentially can in a high TPS environment.
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1930
chandan_jha18 (9/11/2012)
Mirroring solution will work fine to minimize the downtime but please make sure that you have exact versions of sql server with exact level of service pack.

Thanks
Chandan


Good point.

But I would like to add something.

As a DB migration strategy, like moving from old to new MS-SQL flavor, such requirement is not needed. The source can be a lower MS-SQL version. The caveat though, is that moving back won't be possible. But that's the whole idea of Mirroring is if we are using it as a migration strategy to a new environment with a most recent MS-SQL version on it.

As a migration strategy or tool, I honestly prefer (big databases) Mirroring instead of Tlog shipping. To me, Mirroring is easier to configure, assuming all things are in place, like security and network bandwidth.
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1930
MysteryJimbo (9/11/2012)
[quote]
This is why logshipping is a better method of migrating/update database server as there are no restrictions. Logshipping is also guaranteed not to have an impact on the production server where as mirroring potentially can in a high TPS environment.


Sorry, I may not be following you correctly. Do you mind elaborating your statement a bit more?

I do not see how Mirroring can affect during a migration. Assuming the login(s) were created already and SIDs reset on target, it may take just seconds to move the database. I actually done this myself several times with databases between 500GB and 1TB of size.

Both requires good bandwidth, for sure. On both, we need to re-create login(s) and reset SIDs, target instance. But after the Mirror failover, the db is up and running. Using Tlog shipping additional steps are required.

I see myself Mirroring as a Tlog shipping with steroids. And Tlog shipping more data recover oriented, like on a different data center as warm standby.
MysteryJimbo
MysteryJimbo
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2261 Visits: 15346
Mirroring has an processing overhead on the principle server which can, and does, have a performance impact on high TPS servers. I've seen it and discounted this technology for this reason.

Beginning in SQL Server 2008, the principal server compresses the stream of transaction log records before sending it to the mirror server. This log compression occurs in all mirroring sessions.


http://msdn.microsoft.com/en-us/library/ms189852.aspx

Virtually all environments can support and transaction log backup plan which can generally be compressed prior (native or 3rd party) to transporting to a subscriber. Generally they almost always do this anyway. Obviously compressing a log backup has an overhead but this is much smaller than a continual stream to a network connection

I'm not saying mirroring doesn't work. But you are introducing new technology which isn't required and isn't tested on production. This is especially redundant if transaction log backups are already in place.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search