December 14, 2010 at 8:05 am
I'm upgrading several databases to sql 2008 r2 from sql 2008 sp1 using a sync mirror.
Most of the databases are relatively small (10 - 100 GB's). But, I have two databases that are 1.2 TB's.
Has anyone used a mirror to upgrade and did the actual individual database upgrade process take longer time for larger databases?
Any information is greatly appreciated.
December 15, 2010 at 5:43 pm
It does take slightly longer to upgrade the database when they are larger but not a huge amount of time. I recently upgraded a 1.5TB database from SQL 2005 to SQL 2008R2 using the rolling upgrade method with mirroring and it took 1 min 30 seconds to upgrade the database. It should take less time for you since it's only upgrading the version from SQL 2008 to 2008R2.
December 16, 2010 at 12:53 pm
When you manually failedover from SQL 2008 to SQL 2008 r2, what commands did you run on the principal?
ALTER DATABASE DBName
SET PARTNER FAILOVER
alter database DBName
set partner off
restore database DBName
with recovery
Please let me know.
December 16, 2010 at 2:15 pm
There is a known issue with using the rolling upgrade from SQL 2005 to SQL 2008 R2 documented here.
I'm not certain if the same issue applies to SQL 2008 to 2008R2.
So to work around the issue I used the following.
1. Configure a witness
2. Take down the old principal (and thus trigger automatic failover)
3. After failover explicitly suspend DBM on the new principal
4. Remove the witness
5. Restore database dbname with recovery on the new mirror
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply