SQL server 2008 updates
I need to apply an update to SQL server 2008 in a production environment.
Barring backing up the database would there be any other implications in doing this?
Barring backing up the database would there be any other implications in doing this?
ASKER
Hi pcelba,
I have advised my FD that this is EOL and we should update but this is not been approved yet, meanwhile I need to update this version to service pack 4 for a Sage update to be implemented.
I have advised my FD that this is EOL and we should update but this is not been approved yet, meanwhile I need to update this version to service pack 4 for a Sage update to be implemented.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Server 2008 is outside of Microsoft support period already. You should do it in the test environment first.
The SQL Server update works w/o problems if you have enough free space obviously but you should be ready to revert the update back if something fails. To have the C: drive image before the update is worth to have. The database is safe in most of the cases.