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
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
ASKER
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
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
Or you can go with setting up log-shipping. Take log backup every 2 minutes and restore it every 3 minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
I was thinking to setup mirroring between 2005-2008 using same log apply technique and switchover at one point.
Is it possible?
ASKER
Can you reply on my above query please?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant. Please let me try this and I will assign you the points.
Kid Regards
Kid Regards
So, finally what was your take? what you tested and planned with?
ASKER
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
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
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.