upgrading sql 2005 from sp to sp 3

[Former Member]

hi all

i have a question. i need to upgrade my sql 2005 from sp 2 to sp 3 on my live environment because windows7 needs sp3. would there be any issues if i upgrade to sp3?

i just download sp3 into my server and run it?

thanks!

prem

[Former Member · Accepted solution]

Hi Prem,

Windows 7 isn't a server operating system. (That would be Windows 2003 or Windows 2008) And the installation of SQL2005 SP3 is nearly automatic, however, get a FULL backup/snaphot of the system - not just the databases.

[Former Member]

Hi Prem,

Windows7 is not officially supported yet. If you have issue, it must be related to windows7. SP3 should not be an issue.

Thanks,

Gordon