I have a MS Sql server 2008 SP1 running on a Windows server 2008 SP1, I would like to get these upgraded to the latest service packs. Specifically we are seeing performance issues related to "Full text indexing" and upgrading the service pack level of Sql and applying some cumulative updates should fix it.
My question is: I want to make a full image backup of the whole server before updating and just wanted to get some input on the best method to achieve this. We are already taking regular sql backups but I would like a full image to roll back to if the updates make something go sideways.
Can I use Windows Server Backup Services to make this image? I have made many images this way, but never for a server that also runs Sql, any caveats or considerations here? I am also considering Acronis, but would prefer a quick free solution.
The only caveats that I know of is that I should shut down the sql service and any related sql services... anything else?
Many thanks!
If you shut down all SQL Server related services you should have no problem with that. The important things is to ensure that the SQL data (.mdf) and log (.ldf) files are all closed and not in use when the backup is taken.