Site database move from SQL 2005 to 2008 SP1
Hi,
Is a site database move from an existing SQL 2005 server to an new SQL 2008 SP1 server possible or is supported? In this scenario the site database is installed on a remote server.
I understand that an inplace upgrade is supported.
http://technet.microsoft.com/en-us/library/ee344146.aspx
Thanks.
August 31st, 2010 5:05am
Hi,
Install your remote SQL 2008 machine, then apply this porcedure
http://technet.microsoft.com/en-us/library/bb680707.aspx
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2010 6:04am
Thanks for the reply Bachir.
Is it supported tho? The link that I have provided mentions only in-place upgrade but not migration from an existing SQL 2005 server to a newly installed version of SLQ 2008 SP1.
August 31st, 2010 7:41am
Hi,
Both scenarios are supported, don't worry.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2010 8:13am
Thanks Bechir.
August 31st, 2010 8:28am