I run into problems that migrating a SQL Server 2005 database.
The database size is 1 TB and there are two huge tables.
Those tables have over 2 billions records.
The steps that I prefer to take are:
1. Archive those big table
*************************************************************
The SQL Server 2005 are running in two node clusters (SAN) and there are BI packages
Those packages are configured with connection string, etc pointed to old Cluster.
I installed Microsoft SQL Server 2008 R2 with Service Pack 2 in the new three nodes cluster.
However, the BI packages configured, etc pointed to old SQL Cluster nodes.
2. I plan to create SQL Alias.
http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
Would somone help on the best practice to implement?
Tank you.
Edwin