June 3, 2014 at 1:16 am
HI All,
can anyone please telle me the steps to migrate the sql server 2005 to sql server 2008 R2 in the same server.
Thanks in Advance,
Avinash P
June 3, 2014 at 4:43 am
I would install SQL Server 2008R2, take a backup of the databases and restore them in SQL 2008R2.
Don't forget to transfer logins (and other server objects) as well.
You could also detach the databases and attach them in the new instance.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2014 at 5:48 am
Koen Verbeeck (6/3/2014)
I would install SQL Server 2008R2, take a backup of the databases and restore them in SQL 2008R2.Don't forget to transfer logins (and other server objects) as well.
You could also detach the databases and attach them in the new instance.
Agreed. Don't forget to take a full backup before installing anything on the server, just in case something bad happens, and copy the backups to a different server. I once tested the installation of 2005 SP4 and it not only failed to install, but also broke the 2005 SP3 instance that was running. Thank goodness I was testing the SP4 installation and not doing it on a production server.
For what its worth, I think the ideal way is to get a different server, install and patch your 2008 R2 and then migrate the databases to the new server. It'll require coordination with the developers and/or web admins so they point their applications to the new server, but it'll also give you a chance to test on the new server before going live.
June 3, 2014 at 7:11 am
THANK YOU AND HOW TO TRANSFER LOGINS AND USERS.
June 3, 2014 at 7:18 am
p.avinash689 (6/3/2014)
THANK YOU AND HOW TO TRANSFER LOGINS AND USERS.
Ever heard of Google?
In the first page of results:
How to Transfer Logins to Another SQL Server or Instance
ps: your caps lock is broken
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2014 at 8:21 am
Maybe it's just me, but I found digging into the mismatched SIDs to be interesting. My advice would be that if you don't understand how SIDs work to begin with, take the time to dig in and understand it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply