SQL Server with Mr. Denny:

Migration

1

June 25, 2012  2:00 PM

Moving huge amounts of data between data centers



Posted by: Denny Cherry
Data Center Build, Migration, Restore Database, SQL Server

Every once and a while I get the fun project of moving a data center from one location to another, often from a Managed Service Provider to either a CoLo facility or to another Managed Service Provider.  When I'm doing this the data sizes typically aren't small.  In the case of my current project...

May 28, 2012  2:00 PM

Know your app when migrating your data



Posted by: Denny Cherry
Migration, Network Traffic, SQL Server

One of the projects that I'm working on at the moment is moving a data center from being hosted in Dallas Texas up to New Jersey so that it's closer to the companies corporate office in New York City.  As a part of this data center migration the Microsoft SQL Server databases must be moved to the...


May 28, 2012  2:00 PM

Figuring out how log shipping is doing



Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...


November 23, 2009  11:00 AM

Moving a standalone instance to a cluster while keeping the name and IP



Posted by: Denny Cherry
Clustering, Migration, SQL

A little while back I posted about how to move a standalone instance to a clustered instance using a different name and IP, but what do you do when you...


June 12, 2008  5:24 AM

Use caution when upgrading SQL 2008 CTP SSIS packages to RC0



Posted by: Denny Cherry
Beta, Migration, SQL Server 2005, SQL Server 2008, SSIS

A ran across a bit of a problem when upgrading my SQL 2008  CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0.  Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages.  Because of this when I edit all of the script tasks within my SSIS package the...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: