SQL server 2005 to 2008 Upgrade in 15 mins

Hi,
I have done SQL server upgrades using backup/restore and detach/attach.
I have a 150+GB database need to be upgraded to 2008 + latest patches within 15 mins downtime.
What options are available?
Can I use mirroring to replicate database at another node from 2005 to 2008 and at given point carry switchover?

Regards
crazywolf2010Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:
Backup\restore is the best option even with 15 minutes downtime.
Suppose you have 15 minutes downtime planned. So, do full backup before time i.e. some 3-4 hours before the planned downtime, restore it in the target server with norecovery, then 5 minutes before downtime, start differential backup, and then restore the differential at the target server with recovery and do your processing. It will be best.
0
crazywolf2010Author Commented:
Sorry TempDBA,
I have thought of that but that is not what we want. 15 mins is too less for backup/restore. We need something robust.

Thanks
0
TempDBACommented:
Or you can go with setting up log-shipping. Take log backup every 2 minutes and restore it every 3 minutes.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Scott PletcherSenior DBACommented:
You could test DIFFERENTIAL backup, depending on the activity level of your db.

Do a full backup and restore, with NORECOVERY, however long that takes.

Then after that completes, when the downtime starts, do a final DIFFERENTIAL backup, apply it to the previous backup with NORECOVERY (or RECOVERY), then a final:

RESTORE DATABASE dbname WITH RECOVERY;


You would need to test ahead of time and see if the differential backup takes less than 15 mins and what size it is.

If that doesn't work, you will have to use a more complex solution involving mirroring, replication or log shipping.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
crazywolf2010Author Commented:
So are we saying transaction log backup  from 2005 could be applied on 2008 without any issues?
I was thinking to setup mirroring between 2005-2008 using same log apply technique and switchover at one point.
Is it possible?
0
crazywolf2010Author Commented:
Can you reply on my above query please?
0
TempDBACommented:
Yes it is possible i.e. both database mirroring and log shipping.
The only thing once it is moved, you will have to change the compatibiilty mode to 100. And apart from that in log shipping, it won't be in standby mode. You can keep it in norecovery and when all logs are applied, restore with recovery. Check the following link:-
http://www.sqlservercentral.com/Forums/Topic1116973-391-1.aspx#bm1120228

There is one another way which I couldn't think of in the morining. If it is in san environment, you can directly detach and attach the lun and then perform attach database on the new server. Same thing you can do with moving the hard-disk.
0
crazywolf2010Author Commented:
Brilliant. Please let me try this and I will assign you the points.

Kid Regards
0
TempDBACommented:
So, finally what was your take? what you tested and planned with?
0
crazywolf2010Author Commented:
Hi TempDBA,
I had no time so far so I closed question than leaving it open.
I feel during Christmas and new year time there may be an opportunity to play with these things. I will try and do that.  It may not happen even then as there is a change freeze.

I will try and update you.

Regards


0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.